Using Access to send a .pub document as an email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have written code to email input text to a number of customers on my
database at the push of a button. This works fine. However I have now been
asked to write some code that will send the .pub document as the Body of the
email (not as an attachment). The db is Access 2002 and we use Outlook 2003.
Can this be done. The pub document has been design as a newsletter and
contains links to our website etc.
 
rogereverest said:
I have written code to email input text to a number of customers on my
database at the push of a button. This works fine. However I have now been
asked to write some code that will send the .pub document as the Body of the
email (not as an attachment). The db is Access 2002 and we use Outlook 2003.
Can this be done. The pub document has been design as a newsletter and
contains links to our website etc.
Click to expand...

1) You will have to tell your email program you are sending out HTML.
SendObject doesn't support this.

2) You will need to somehow fetch the HTML from the pub file or
generate the HTML and put it into a string variable which would then
be the body of the email.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top