Putting a clickable link in the body of email sent from Excel

**raehippychick** · 11-18-2008, 12:09 PM

Hi again

I've managed to get the following macro working except for one small thing - the link to the folder where the spreadsheet (that will be attached to the email) resides (which I got to work fine in a macro to send out tasks) just ends up as plain text and is not clickable

Can anyone help me to make this link clickable in the email so that when the recipient receives the email they can just click on the link and go straight to the relevant folder please?

(I've highlighted the line with what I would like to work as a link in red)

Please Login or Register  to view this content.

Many thanks in advance

Rae

**Leith Ross** · 11-18-2008, 02:35 PM

Hello Rae,

I posted this yesterday, but I will repost it again for you.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**raehippychick** · 11-19-2008, 06:04 AM

Thank you for that - it works really well, and clicks wonderfully to the correct folder

Now I'm going to try and work out how to incorporate it with with my macro which sends files to people from a list in the spreadsheet so I can send files and links together

Not sure why I missed it yesterday as I always do a search before I post a question, but my PC was being very silly and crashing a lot so it could be that

Thanks again

Rae

Putting a clickable link in the body of email sent from Excel

LinkBack

Thread Tools

Rate This Thread

Display

Putting a clickable link in the body of email sent from Excel

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions