Quick way of Hyperlinking onto a spreadsheet

Chancy · #2 04-08-2015, 10:30 AM

Quote:

Originally Posted by Tony Singh

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
hyperlinking a table row	userofword	Word Tables	3	03-21-2014 03:29 PM
Hyperlinking	kgoshia	Word	1	04-13-2013 12:16 AM
Table of contents: Hyperlinking	tays01s	Word	0	08-03-2011 01:41 PM
MS Outlook - Hyperlinking	coolpeter86	Outlook	0	12-02-2010 12:04 PM
Hyperlinking pdf file into spreadsheet	mygoat	Excel	0	05-09-2006 11:59 PM