PDA

View Full Version : Change font of msg body using VBA



Zack Barresse
12-16-2005, 10:10 AM
I have a message that I created and saved as a draft (.oft). It was saved in the format I wanted it: four dates in a sentence, dates are bolded.

I am programming this from Excel via VBA.

Outlook is referenced making use of Early Binding.

I run my code, which inserts the correct dates into the correct locations of the body, then displays the message. But the formatting is lost.

Is there anyway to retain the formatting or add formatting to the existing/altered body of the mail message?

I can post the code if you like, but it's quite large. I am using a dialog sheet to populate with checkboxes which then will be taken to the mail message body.

This is not an emergency of any kind, just more of a minor question, the routine works exactly the way I intended it to. :)

Shazam
12-16-2005, 03:02 PM
This link might help you but not sure.


http://www.danielklann.com/excel/sending_a_range_as_the_body.htm

Zack Barresse
12-17-2005, 02:10 PM
Sorry, forgot to mention, I do not use HTML at all and Word is not my default mail editor.