Fill 'Subject' and Body of an e-mail

I'm having the following code in a Userform, it is creating an e-mail, putting an textbox entry into the Addressee box.

Please Login or Register  to view this content.

Works fine.

Now what I'd like to do is to put LNsubject into the Subject field of the mail.

Also I'd like to set a standard text message in the body of the mail.

Can you provide some guidance how to achieve those goals?

Hi Gabor,
It looks like you are going from Excel to Email to send good form letters.

It makes me wonder why you don't use Micorsoft Word and Mail Merge in your Excel data to send the email?

http://support.microsoft.com/kb/294694 or
http://office.microsoft.com/en-us/wo...005187257.aspx or
https://www.uwec.edu/help/Word07/MM-email.htm

In terms of URLs etc

Please Login or Register  to view this content.

Note the above is restricted to 255 chars.

In short, first variable is ? thereafter & ... formatting achieved via Hex

I am presuming you're using this approach because mail clients are unknown / may vary

I am not familiar with the tools you refer to, but I will have a look.
At current I have doubt Word Merger can do this from an Excel UserForm.

DonkeyOte,

To your question: The original list is a download from a system into an excel file. I contains names in reverse order, like 'Doe, John' format. The email system of the company can recognize the names if I enter John Doe, so I need to turn the string around.

To your suggestion: Where in the code shall I insert the line you are recommending?

Thanks

Stupid me, I know where to insert.

Originally Posted by Gabor

To your question: The original list is a download from a system into an excel file. I contains names in reverse order, like 'Doe, John' format. The email system of the company can recognize the names if I enter John Doe, so I need to turn the string around.

My question was:

Originally Posted by D.O

I am presuming you're using this approach because mail clients are unknown / may vary

If the mail client is unknown or varies by machine then the mailto method is useful for obvious reasons.

If however the mail client is constant and has an object model of some description (eg Outlook) then you would be best served using it.

The mailto method as outlined has some relatively significant restrictions (255 chars)

Finally I stopped fiddling with it at this state:

Please Login or Register  to view this content.

Thanks for the help.