Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Excel Help Forum » Microsoft Office Application Help - Outlook Help forum » Outlook Programming » email formatting in vba

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 05-29-2009, 04:28 AM
LilyMarie LilyMarie is offline
Registered User
  
Join Date: 26 Feb 2009
Location: U.S
MS Office Version:Excel 2003
Posts: 42
LilyMarie is becoming part of the community
email formatting in vba

Please Register to Remove these Ads

Hello all,

I generate emails through vba and I need to center align the text in the body of the email. How do I do that?

Thanks!!
Reply With Quote
  #2  
Old 05-29-2009, 06:44 PM
mrice's Avatar
mrice mrice is offline
Forum Guru
  
Join Date: 22 Jun 2004
Location: Surrey, England
MS Office Version:Excel 2007
Posts: 1,851
mrice has been very helpful
Re: email formatting in vba
You could try using the HTMLBody property of the MailItem object and using appropriate HTML tags to get the centering.
__________________
Martin

Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
Reply With Quote


Reply

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Linear Mode Linear Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Contact Us - ExcelTip.com - Archive - Top