Help with message format

[daverunt]

Hi,

I want to be able to create a message body for email on a worksheet, which includes hyperlinks.

What would be the best method?


I'm currently using a Textbox on my Excel sheet to create the body of an email message - example below.
I use the 'shapes' object code below to get the text.

There are a couple of problems with this.
Can't drop it into an .HTMLBody mail - no tags it just becomes one line of garbage
Can't seem to read each line and format it to HTML dynamically

I have tried just a merged set of rows and would rather try for something better.

Any ideas gratefully accepted/investigated.


Msg example:

Hi xxxxr,

If not already updated you must update to framework build 10v0.

Framework
https://www.dropbox.com/s/kaz6n0uycwb4j4d/10v0.msi?dl=0

Documents
https://www.dropbox.com/s/drhyshjui0xs5zn/Supporting_Docs_10v0.zip?dl=0

Best Regards

MailBody = Sheets("Messages").Shapes("Box 1").OLEFormat.Object.Text

 

[ranman256]

did you try : .Body=xxxxxx

 

[daverunt]

Thanks but this doesn't give working hyperlinks in a mail.

 

[daverunt]

To get the hyperlinks to copy into the mail body as working links, I have reverted to concatenating a few cells for the message content instead of a TextBox.
As long as Outlook default is HTML format mails the hyperlinks in the mail work.

It'll have to do.