Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Control format when sending Outlook/Exchange email via Access


Message #1 by "John K. King" <johnking@o...> on Sun, 19 Jan 2003 22:23:59
Hi:

From Access2000, I'm sending an email via Outlook/Exchange.

If I look at the email in Outlook prior to sending it, it looks great. 
Font is Courier New 8pt.

Then send it.

Upon receiving it, the font is very small. Doesn't matter if the email 
client is another outlook installation, or Eudora (pop3).

I believe that the problem is that the email is sent in RTF format instead 
of as plain text. I've sent it without modification and seen the small 
font. I've re-generated the message and, prior to sending, edited the 
message and changed the format manually (Format>Plain Text)from RTF to 
Plain Text. Viewing the sent document provides me with what I wanted to 
see.

Outlook (Tools>Options>Mail Format) is configured to send using Plain 
Text, but that apparently affects only manually created messages.

I can't find the mechanism to set the format type for an Outlook message 
via automation.

Any help is appreciated.

Thanks,
JK
Message #2 by "Leo Scott" <leoscott@c...> on Sun, 19 Jan 2003 23:25:50 -0800
If you open an inspector on the mailitem before you send it you can use the
commandbars collection to execute the button that will set the mailformat to
plain text.  If you just set the body property to the string of the message
you want to send the message format will default to the default format for
the Outlook client you are using to send the messages.

|-----Original Message-----
|From: John K. King [mailto:johnking@o...]
|Sent: Sunday, January 19, 2003 10:24 PM
|To: Access
|Subject: [access] Control format when sending Outlook/Exchange email via
|Access
|
|
|Hi:
|
|From Access2000, I'm sending an email via Outlook/Exchange.
|
|If I look at the email in Outlook prior to sending it, it looks great.
|Font is Courier New 8pt.
|
|Then send it.
|
|Upon receiving it, the font is very small. Doesn't matter if the email
|client is another outlook installation, or Eudora (pop3).
|
|I believe that the problem is that the email is sent in RTF format instead
|of as plain text. I've sent it without modification and seen the small
|font. I've re-generated the message and, prior to sending, edited the
|message and changed the format manually (Format>Plain Text)from RTF to
|Plain Text. Viewing the sent document provides me with what I wanted to
|see.
|
|Outlook (Tools>Options>Mail Format) is configured to send using Plain
|Text, but that apparently affects only manually created messages.
|
|I can't find the mechanism to set the format type for an Outlook message
|via automation.
|
|Any help is appreciated.
|
|Thanks,
|JK
|

Message #3 by amy.bender@p... on Wed, 22 Jan 2003 18:25:43
If your client has it, snapshot work well for retaining format of a report 
sent in email. But it also doen't allow them to make any changes.

  Return to Index