Sending outlook mail using VBA

Hello icylemontea,

I am not really familiar with the Mac Excel 2004, other than there are many differences between the PC and Mac, especially in the use of advanced code. I have contacted another moderator who is very familiar with Macs to take a look at your post.

Just so we are all on the same page, do you want to include a hyperlink in the email body or do you want to include the URL text? It was not clear to me which you wanted.

Hello icylemontea,

Please update your profile to include Excel 2010. It will help everybody when answering any questions you have. As for the link, it has to added in HTML, which you can do in Outlook. Instead of Body you have to use htmlBody. The message must be a string that includes the proper HTML tags for formatting and to provide the link.I can code this for you if you want.

It's rather curious to have the property .Readreceiptrequested
set to False after sending the mail.
I don't know whether it's possible to show the mail after sending it (outlook.display).
I also fear that you didn't put something into 'NameOfWorkbook'
try this:

Please Login or Register  to view this content.