Links do not work once sent via outlook

**pauluk** · 09-29-2009, 07:14 AM

Hi all,

Am using ronebruin mail VBA to send mails from outlook http://www.rondebruin.nl/mail/folder3/mail4.htm However the links do not appear to work.

If a cell has a hyperlink such as www.google.co.uk then it appears but it is no active. The links work in excel but just not when sent via outlook. any ideas???

Thanks in advance

**royUK** · 09-29-2009, 07:23 AM

Which set of code are you actually using?

**DonkeyOte** · 09-29-2009, 07:26 AM

could you post a sample file with a range reflecting your real file, ie that contains links which are failing to generate correctly in OL ?

is OL displaying the messages in plain text ?

Originally Posted by royUK

Which set of code are you actually using?

Roy, other than the notes (binding etc) all the code is required - the 2nd section is a Function for converting the Range

**pauluk** · 09-29-2009, 07:31 AM

The code is as per the link but attached below.

As for the links it is every hyperlink in the excel file, so if i create a hyperlink in a cell it works in excel but once it has been outputted by the code it is no longer a hyper link. I am assuming that it may be something with the rangeto html function but from looking at it basically saves it as a web page and publish's it

Please Login or Register  to view this content.

**DonkeyOte** · 09-29-2009, 07:32 AM

I'm running 2007 presently but I could only replicate the lack of link issue if I set OL to display the message in Plain text format... I will try and test on a pre 2007 environment later (unless someone else chooses to in the meantime...)

**pauluk** · 09-29-2009, 08:12 AM

My out look is set to rich text

**pauluk** · 09-30-2009, 06:01 AM

Am using OL 2003 XL 2003

OL mail format is set to Rich text no links working
OL mail format set to HTML no links working
OL mail format to plain text no links working

If i copy and paste manually into ol links work.

I am assuming that it is the rangetohtml function at first i though it was the because the HTMLtype was set to xlHtmlstatic but there is no other selction unless you wantinteractivity which means activex which i cannot use due to restrictions. Am I there for correct to assume that if my network security setting prohibit activex then an alternative solution needs to be sourced?

**pauluk** · 09-30-2009, 06:35 AM

Ok after a looking at the function it is the following code snip that is causing the hyperlinks to be lost

Please Login or Register  to view this content.

As the function uses pastes special to paster the values.
In my spreadsheet people use the insert>hyperlink for the hyperlinks.
What would i need to change? My mind has drew a blank
It's prob the following line which needs changing just to astright forward

Please Login or Register  to view this content.

**pauluk** · 09-30-2009, 08:22 AM

hi i got this working now. Brain working slow

i changed the following

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Sometimes we over look the small things and think its something alot bigger then what it actually is. If you have been working on this thanks for your time