Thread: [Solved] Quick way of Hyperlinking onto a spreadsheet
View Single Post
 
Old 04-08-2015, 10:30 AM
Chancy Chancy is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default
Quote:
Originally Posted by Tony Singh View Post
Hi

I have a spreadsheet that I use too email out pdf attachments to around 60 colleagues each month. The task of right clicking and attaching the hyperlink is quite long winded when I have to do this around 60 times.

I am looking for a faster way to do this. Would appreciate any help on this.

Thanks
Tony
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.
Reply With Quote