Results 1 to 2 of 2
  1. #1
    Soule is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2011
    Posts
    58

    Losing Formatting & Pic Position in Rich Text Template Automated Send

    Hi, Everyone,

    I'm sending an automated e-mail from an Access form button through Outlook.

    My environment is:
    - Access 2007
    - .accdb file
    - Button code in standard module pointed to with event procedures using Call subs
    - Am in datasheet view when compiling/stepping through/running
    - Early binding w/Intellisense
    - Libraries (in this order):
    VB for Apps
    MS Access 12.0 Obj. Lib.
    MS Outlook 12.0 Obj. Lib.
    MS OFC 12.0 Access db engine Obj. Lib.
    MS VB for Apps Extensibility 5.3
    MS VBScript Regular Expressions 5.5
    MS ActiveX Data Objects 2.8 Lib.
    OLE Automation
    - No compile, step-through or run-time errors

    The Outlook details are:

    - Outlook 2007
    - Options set to send e-mail as Rich Text files
    - My template is saved as a Rich Text .oft file

    My code uses a "Msg.Body = olFormatRichText" statement

    Problem:
    My buttons run fine (template opened, populated, sent). I've been using my Outlook account to send the mails to myself for testing. The sends look fine in the "Sent Items" folder, but when I receive them in my Inbox, two aspects of the formatting are messed up.
    1) Any bolding is lost.
    2) The embedded .jpg picture is moved to the bottom of the mail below the text from the top where it should be.



    I'm not sure how to start fixing the loss of bolding issue.

    I've tried everything I could think of to fix the picture position/alignment including changing the positioning options (in line with text, behind text, top & bottom, in front of text, etc.), adjusting the alignment decimals of "absolute positions", using general top/bottom/right or left of margin settings and unchecking "Smart Copy & Paste" option.


    Has anyone dealt with these two problems in a Rich Text send?


    Even small infos. will be very valuable.

    Thank you.

    Frank

  2. #2
    Soule is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2011
    Posts
    58
    SOLVED...

    As it turns out, I decided to go back to HTML template, olformatHTML force in code and set my mail type Outlook option to HTML as well.

    Miraculously, when I removed the graphic due to an administrative request, the mail is received perfectly to internal intranet or external internet recipients whether sent manually or through automation!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-23-2012, 07:21 PM
  2. Losing information from a text box
    By Gezza in forum Forms
    Replies: 8
    Last Post: 01-19-2012, 09:17 PM
  3. Set format of rich text field
    By silverspr in forum Programming
    Replies: 0
    Last Post: 03-28-2011, 09:07 AM
  4. Rich Text Boxes (Word OLE vs ?)
    By nichojo in forum Programming
    Replies: 1
    Last Post: 08-30-2010, 12:11 PM
  5. Macro to set rich text attributes?
    By EER in forum Programming
    Replies: 0
    Last Post: 03-04-2009, 09:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums