E-Newsletter from access

[yn]

I need help in creating an electronic newsletter (word or html format )and
automate it from Access 2000 application to Outlook 2000. I need to embed
the document/ graphics in the body, not as an attachment.
Thanks

 

[Tony Toews]

I need help in creating an electronic newsletter (word or html format )and
automate it from Access 2000 application to Outlook 2000. I need to embed
the document/ graphics in the body, not as an attachment.

You can also use Stephen Leban's HTML Editor to create a HTML
formatted string. http://www.lebans.com/htmleditor.htm. Then see the
Sample Code illustrating looping through a DAO recordset page at the
Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm. Then see
the Outlook specific links at
http://www.granite.ab.ca/access/email/outlook.htm to automate Outlook.

Note this will all require a fair amount of VBA code.

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

 

[yn]

Thanks Tony. Always very helpful...

You can also use Stephen Leban's HTML Editor to create a HTML
formatted string. http://www.lebans.com/htmleditor.htm. Then see the
Sample Code illustrating looping through a DAO recordset page at the
Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm. Then see
the Outlook specific links at
http://www.granite.ab.ca/access/email/outlook.htm to automate Outlook.

Note this will all require a fair amount of VBA code.

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