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
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
