+ Reply to Thread
Results 1 to 2 of 2
  1. 05-29-2009, 04:28 AM #1
    LilyMarie
    LilyMarie is offline
    Registered User
    Join Date
    02-26-2009
    Location
    U.S
    MS-Off Ver
    Excel 2003
    Posts
    42

    email formatting in vba

    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 Reply With Quote
  2. 05-29-2009, 06:44 PM #2
    mrice
    mrice is offline
    Forum Guru mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2007/2010
    Posts
    2,806

    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.

    If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0