Access and Outlook Templates

[ReportSmith]

I have a button on a form in Access that, when clicked, should open a
template in Outlook that is already populated with all of the necessary data
(To:, Subject:, Message body text, etc) and formatted with line breaks and
different font sizes/colors.

I have the template set up (saved as type 'Outlook Template') and the
SendObject command written in Access VBA, but can't get it to work properly.
The workaround I came up with opens the message on the default template,
fills in all of the necessary fields, but is unformatted (I would need to
format before clicking the 'Send' button).

I tried adding one more comma at the end of the statement and the name of
the Outlook template (in quotes), but get an error. I saw another posting
here that pointed me to the Outlook discussion group, but no luck there
either.

Can anyone help? Thanks in advance.

 

[David H]

You're better off using office automation to send the email using Outlook. As
it gives you full control over the MailItem.

http://msdn.microsoft.com/en-us/library/aa167323(office.11).aspx
http://support.microsoft.com/default.aspx/kb/153311