B
BruceS
Would appreciate input from other Office programmers regarding best approach
to automate the delivery of periodic html emails. Here's how they want
system to work:
1- Using a custom form, the user browses to and selectes a html file (a
company newletter)
2- User then selects "types" of contacts to receive the email by checking
boxes on the form.
3- List of email addresses is queried from an Access "contact" database.
4- Upon clicking a button on the form, the selected html file is delivered
to the email addresses, which are loaded into "BCC" field so that no one can
see the other addresses.
I've worked pretty extensively with Access, but never done any custom coding
(aside from a few macros) in Word or Outlook. I'm familiar with SendObject
in Access, but it creates text emails with the html file as an attachment.
Question 1: Which is best application to use for development, Word, Access
or Outlook?
Question 2: Does anyone know of any example code I can use within the
selected application?
Question 3: If I use SendObject in Access, how does one get the html code
from the selected file into the body of the email?
Thanks for your input!
Bruce
to automate the delivery of periodic html emails. Here's how they want
system to work:
1- Using a custom form, the user browses to and selectes a html file (a
company newletter)
2- User then selects "types" of contacts to receive the email by checking
boxes on the form.
3- List of email addresses is queried from an Access "contact" database.
4- Upon clicking a button on the form, the selected html file is delivered
to the email addresses, which are loaded into "BCC" field so that no one can
see the other addresses.
I've worked pretty extensively with Access, but never done any custom coding
(aside from a few macros) in Word or Outlook. I'm familiar with SendObject
in Access, but it creates text emails with the html file as an attachment.
Question 1: Which is best application to use for development, Word, Access
or Outlook?
Question 2: Does anyone know of any example code I can use within the
selected application?
Question 3: If I use SendObject in Access, how does one get the html code
from the selected file into the body of the email?
Thanks for your input!
Bruce