Quote:
Originally Posted by Chancy
The hyperlink is to the colleagues' email addresses?
You can highlight all the cells containing the email addresses (row or column), copy and paste into the "To:" field. At least, this works for Gmail. Not sure about other email programs.
|
Hi Chancy
Sorry, I did not explain clearly. The Pdf's are individual, so in the first column I have the name of the person followed by their email address in Col: B, then finally the Hyperlinks to the Pdf files in Col:C.
The Pdf's are all different a relate to the individual recipient.
Its the Hyperlinking which I do manually that takes time. Hope this is more clear.
Tony