[AccessD] HTML Email from Access - Progress

MessageAs long as the SendObject topic is open:  does anybody really know
how to use the TemplateFile parameter?  This would seem to be the perfect
mail merge tool, but I can't find documentation anywhere, and my attempts
silently fail (a plain vanilla email is produced, and that's all).

Thanks.
Steve Capistrant
Symphony Information Services
scapistrant at symphonyinfo.com
Phone: 612-333-1311
www.symphonyinfo.com
212 3rd Ave N, Ste 404
Minneapolis, MN 55401


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steve Capistrant
Sent: Tuesday, August 19, 2003 9:17 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] HTML Email from Access - Progress


Thank you, Andy.  You are right; I was trying to stuff the whole HTML
document into the HTMLBody, and it did include pictures, not just text with
picture references.

There seems to be two key variations to HTML email from Access, and I'm
going to experiment with both:

1) Using SendObject:  filling up the MessageText parameter by reading an
HTML file in line by line.  Pictures must be loaded on website because
SendObject doesn't allow creation of email attachments.  This has attraction
because I'm not limited to Outlook -- any MAPI compliant email application
will do.

2) Using Outlook Automation:  feeding the PicturePathAndFile into the
.Attachments property and the FileNameOnly into the .HTMLBody property.
The attraction here is slightly less work (you don't have to ftp your images
to your website), and the user's ability to view the email offline (locally
stored pictures).

I'll let you know how it goes.

Steve Capistrant
Symphony Information Services
scapistrant at symphonyinfo.com
Phone: 612-333-1311
www.symphonyinfo.com
212 3rd Ave N, Ste 404
Minneapolis, MN 55401

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030819/231942a6/attachment-0001.html>