Macro to Send Email with text in body

**Jiptastic** · 02-19-2013, 05:48 PM

The code below works pretty well at bringing up an email, or even sending. Does anyone know how to write in the body of the email? I
previously had some code that would paste inside the email, but it would overwrite the autosignature which was annoying. At the moment I just want to have the same few sentences put in the body, but I want to keep the signature at the bottom.

Please Login or Register  to view this content.

**Jiptastic** · 02-22-2013, 05:06 PM

Bump no reply

**xlbiznes** · 02-23-2013, 03:58 AM

Hi,

All you need to do is to add the subject property and fill it up with the string.

I have added one single line of code to yours. Hope this helps.

Happy Computing.

Please Login or Register  to view this content.

**Jiptastic** · 02-25-2013, 11:32 AM

That code runs fine, but it erases my autosignature. Do you know of any way to avoid this?

**xlbiznes** · 02-25-2013, 02:52 PM

Hi,

does your signature contain plain text or a mix of text and images ?

If it is just text , then we can simply append it to the message body.

**Jiptastic** · 02-25-2013, 03:23 PM

It's a mix of text and images and it uses different font colors. It automatically comes up with the email until I put in the "Body" line of code.

**xlbiznes** · 02-25-2013, 03:45 PM

In that case you need to search for a file mysig.htm. This would be a HTML style file. Get the contents of this file into a string and replace .Body with .HTMLBody. Append the message with the contents of mysig.htm. Try it out.

**mc84excel** · 02-25-2013, 09:29 PM

Two suggestions:
1. I had a similar problem trying to get workbooks in a folder emailed through Outlook. See the code in my thread to see if you can take ideas from that: http://www.excelforum.com/excel-prog...closed-wb.html
2. There is a very good page covering Excel VBA & Outlook on Ron de Bruins website. It also contains example workbooks you can download. See here: http://www.rondebruin.nl/sendmail.htm

Hope that this is of some help to you.