Sending outlook mail using VBA

[icylemontea]

Hi,

I want an email to be sent, which contains a link to the workbook once a user has filled in a userform and clicks a button on the userform. I have the following code:

Please Login or Register  to view this content.

However, I'm always getting invalid qualifier or variable not defined. Could someone please help? Thanks in advance! =)

[mrice]

The continuation character in

Please Login or Register  to view this content.

might be to blame. Try removing it.

[icylemontea]

It didn't work =(
Now I'm getting:
Run-error
Automation error
invalid syntax

[Leith Ross]

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.

[icylemontea]

Hi Leith,

Sorry, I'm actually on a different computer using excel 2010 at the moment.
Regarding the body of the email, I wanted a hyperlink to the excel file.

Thanks for your help

[Leith Ross]

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.

[snb]

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.

[icylemontea]

Hi,

I changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and that seems to have done the trick.
Thanks guys for your help.

Leith, would you mind showing me the coding for .htmlbody?
Thanks a lot!