PDA

View Full Version : VBA Coding: Font Change



C2Code
07-18-2012, 05:52 AM
Hello,
I have a macro that creates an Outlook email by pulling material form Excel. I can't get the font, etc to change in the email message itself. I have code along the lines of:

.body = "You are invited to" & PLocation & on the & PDate & Chr(13) & Regards & PSignature

Say I wanted to bold the PLocation, italicize and change size of PSignature, how would I do that? PLocation.Font.Bold = True, didn't change anything in my email body.

Thanks for the help!