Results 1 to 4 of 4
  1. #1
    3 Star Lounger Omega3's Avatar
    Join Date
    Jan 2004
    Location
    Los Angeles, California, USA
    Posts
    343
    Thanks
    2
    Thanked 1 Time in 1 Post

    Email and Formatted Text (2002)

    I am trying to send an email from Access using the SendObject method. It has a messagetext argument for the body of the email. Am I correct that I can not use it to include a formatted text message (bold, italic, bullet list, etc.)?

    If I use an Outlook object, will I be able to create formatted messages in the body of the text? Or can I copy formatted text from a word document and paste it into an Outlook message and retain the formatting?
    You know it's time to diet when you push away from the table and the table moves.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Email and Formatted Text (2002)

    You are correct that SendObject doesn't let you create a formatted message.

    If you use Outlook Automation, you can send a message in HTML format (set the BodyFormat property to olFormatHTML) and set the HTMLBody property of the message. You will need to know how to write HTML. Example from the Outlook VBA help:

    Item.HTMLBody = "<HTML><H2>My HTML page.</H2><BODY>My body.</BODY></HTML>"

  3. #3
    3 Star Lounger Omega3's Avatar
    Join Date
    Jan 2004
    Location
    Los Angeles, California, USA
    Posts
    343
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Email and Formatted Text (2002)

    Thanks Hans. I do know HTML so I'll give it a try and see how dangerous I can become! <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
    You know it's time to diet when you push away from the table and the table moves.

  4. #4
    3 Star Lounger Omega3's Avatar
    Join Date
    Jan 2004
    Location
    Los Angeles, California, USA
    Posts
    343
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Email and Formatted Text (2002)

    Hey Hans,

    Just wanted to let you know that I followed your directions and created an html file and imported it into Access and attached it to an Outlook object. It works great!

    Thanks for all the help and advise you give everyone here! <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23>
    You know it's time to diet when you push away from the table and the table moves.

Posting Permissions

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