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