Making a filepath a hyperlink in an email generated with code

**MissDB** · 03-14-2014, 07:21 AM

Hi,

I have the following code to do something similar to above but I need to add the filepath as a hyperlink to the email along with the body text. I have 4 cells in the Excel workbook that contain 1) Who to sen to:, 2)The Subject:, 3) A sentence for the Body of the email and 4) The filepath of the workbook as a hyperlink.

I want to add both the Body text and the hyperlink to the email so that the person opening the email can click on the link and open the file.

Any help would be greatly appreciated!

Thanks

Please Login or Register  to view this content.

**adyteo** · 03-14-2014, 08:30 AM

try to add this:
ActiveSheet.Hyperlinks.Add Anchor:=Range("AY5"), Address:="http://www.microsoft.com", TextToDisplay:=.Range("AY5")

**MissDB** · 03-14-2014, 08:47 AM

Hi,

Thank you so much for replying. The link I need is not a website but a filepath of a file saved on a Share Drive. How would I adapt your code for this? Also where in the code would I place this?

Originally Posted by adyteo

try to add this:
ActiveSheet.Hyperlinks.Add Anchor:=Range("AY5"), Address:="http://www.microsoft.com", TextToDisplay:=.Range("AY5")

**adyteo** · 03-14-2014, 09:13 AM

Add it after With ActiveSheet
change http... to "D:\Documents and Settings\xxx\My Documents\Personal\yyy.pptx" or wherever your file is located

**MissDB** · 03-14-2014, 09:18 AM

Hi,

I know have this but it is not working:-

Please Login or Register  to view this content.

Originally Posted by adyteo

Add it after With ActiveSheet
change http... to "D:\Documents and Settings\xxx\My Documents\Personal\yyy.pptx" or wherever your file is located

**adyteo** · 03-14-2014, 09:26 AM

Please Login or Register  to view this content.

**MissDB** · 03-14-2014, 09:49 AM

This gives an invalid procedure call or argument Run Time Error

**MissDB** · 03-14-2014, 09:55 AM

The file path is in AY6 but I am not sure how to write it. When the person using the workbook saves it I need cell AY6 to update with the new file location. I then need this to be added to the email as a clickable link. The Body of the email is a sentence that is in cell AY5. I just need to add the file path in AY6 as a hyperlink under this sentence with the hyperlink.

**adyteo** · 03-14-2014, 09:55 AM

Please Login or Register  to view this content.

**adyteo** · 03-14-2014, 09:56 AM

if it does not work in excel then you would need to access Outlook methods from excel to insert the hyperlink in Outlook.

**MissDB** · 03-17-2014, 07:33 AM

I think I may have to leave it there then. My knowledge/skill level doesn't extend to what I need to do I don't think. Am a real beginner with all this. Thanks anyway.

Making a filepath a hyperlink in an email generated with code

LinkBack

Thread Tools

Rate This Thread

Display

Making a filepath a hyperlink in an email generated with code

Re: Making a filepath a hyperlink in an email generated with code

Re: Making a filepath a hyperlink in an email generated with code

Re: Making a filepath a hyperlink in an email generated with code

Re: Making a filepath a hyperlink in an email generated with code

Re: Making a filepath a hyperlink in an email generated with code

Re: Making a filepath a hyperlink in an email generated with code

Re: Making a filepath a hyperlink in an email generated with code

Re: Making a filepath a hyperlink in an email generated with code

Re: Making a filepath a hyperlink in an email generated with code

Re: Making a filepath a hyperlink in an email generated with code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Change Font Size/Color on one line of an email automatically generated by a code.

How to create email, adn add hyperlink for workbook filepath?

Adding A Hyperlink To Excel Generated Email

Code to scrape system generated outlook email doesn't get all the data

embedding user-defined hyperlink into auto-generated email

Bookmarks

Bookmarks

Posting Permissions