Hello
First 'Seasons Greetings' to all you users. I have a spreadsheet with the root path for over 1,000 documents that get sent out via a mail merge. The problem is that although this system works perfectly well, if the document contains errors that recipient will always have a hard copy of that file and it is a bit unprofessional. What I would like to do is just send a link to a Dropbox account where that file is stored.
My question is, is there a way I could open each file, get the drop box shared link (from the dropbox badge) into the clip board, then copy that link back into the spreadsheet next to the record.
Hope my question is clear enough and a big thanks for anyone who could consider a solution.
John
First 'Seasons Greetings' to all you users. I have a spreadsheet with the root path for over 1,000 documents that get sent out via a mail merge. The problem is that although this system works perfectly well, if the document contains errors that recipient will always have a hard copy of that file and it is a bit unprofessional. What I would like to do is just send a link to a Dropbox account where that file is stored.
My question is, is there a way I could open each file, get the drop box shared link (from the dropbox badge) into the clip board, then copy that link back into the spreadsheet next to the record.
Hope my question is clear enough and a big thanks for anyone who could consider a solution.
John
