B
BruceS
Hi, everyone!
Would appreciate input from other Office developers on the best way to
automate the sending of html emails. This is how they want the system to
work:
1- Using a custom form, the user selects the html file (a newsletter) to send.
2- User then selects the "types" of contacts to receive the email by
checking boxes.
3- When a button is clicked, the email is created with the html file as the
body and the BCC list is populated by a query of the contacts in an Access 2K
database, then sent by Outlook 2K.
I've worked pretty extensively with Access but never done any real
customization, aside from a few macros, in Word or Outlook. In Access, I
tried using
SendObject acSendNoObject, acFormatHTML, ...
and copying the html source code into the "Body" parameter, but it creates a
"plain text" email with the html source code as the body. (When the email is
received, the body is text and is not displayed as the output of the html.)
Question 1: Which program, (Access, Word or Outlook) would be the easiest
to use for development of this function?
Question 2: Does anyone know of any sample code I could use for the
preferred application?
Thanks for your help!
Bruce
Would appreciate input from other Office developers on the best way to
automate the sending of html emails. This is how they want the system to
work:
1- Using a custom form, the user selects the html file (a newsletter) to send.
2- User then selects the "types" of contacts to receive the email by
checking boxes.
3- When a button is clicked, the email is created with the html file as the
body and the BCC list is populated by a query of the contacts in an Access 2K
database, then sent by Outlook 2K.
I've worked pretty extensively with Access but never done any real
customization, aside from a few macros, in Word or Outlook. In Access, I
tried using
SendObject acSendNoObject, acFormatHTML, ...
and copying the html source code into the "Body" parameter, but it creates a
"plain text" email with the html source code as the body. (When the email is
received, the body is text and is not displayed as the output of the html.)
Question 1: Which program, (Access, Word or Outlook) would be the easiest
to use for development of this function?
Question 2: Does anyone know of any sample code I could use for the
preferred application?
Thanks for your help!
Bruce