<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=216073214-19082003>As
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).</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=216073214-19082003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=216073214-19082003>Thanks.</SPAN></FONT></DIV>
<P><FONT size=2>Steve Capistrant<BR>Symphony Information
Services<BR>scapistrant@symphonyinfo.com<BR>Phone:
612-333-1311<BR>www.symphonyinfo.com<BR>212 3rd Ave N, Ste 404<BR>Minneapolis,
MN 55401<BR></FONT></P>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Steve
Capistrant<BR><B>Sent:</B> Tuesday, August 19, 2003 9:17 AM<BR><B>To:</B> Access
Developers discussion and problem solving<BR><B>Subject:</B> RE: [AccessD] HTML
Email from Access - Progress<BR><BR></FONT></DIV>
<DIV><SPAN class=656414913-19082003><FONT face=Arial color=#0000ff size=2>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. </FONT></SPAN></DIV>
<DIV><SPAN class=656414913-19082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=656414913-19082003><FONT face=Arial color=#0000ff size=2>There
seems to be two key variations to HTML email from Access, and I'm going to
experiment with both:</FONT></SPAN></DIV>
<DIV><SPAN class=656414913-19082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN><SPAN class=656414913-19082003><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=656414913-19082003><FONT face=Arial color=#0000ff size=2>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. </FONT></SPAN></DIV>
<DIV><SPAN class=656414913-19082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=656414913-19082003><FONT face=Arial color=#0000ff size=2>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).</FONT></SPAN></DIV>
<DIV><SPAN class=656414913-19082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=656414913-19082003><FONT face=Arial color=#0000ff size=2>I'll
let you know how it goes.</FONT></SPAN></DIV>
<DIV><SPAN class=656414913-19082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=656414913-19082003></SPAN><SPAN
class=656414913-19082003></SPAN><FONT size=2>Steve Capistrant<BR>Symphony
Information Services<BR>scapistrant@symphonyinfo.com<BR>Phone:
612-333-1311<BR>www.symphonyinfo.com<BR>212 3rd Ave N, Ste 404<BR>Minneapolis,
MN 55401<BR></DIV></FONT>
<DIV class=OutlookMessageHeader dir=ltr align=left><SPAN
class=651143519-30072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV></BODY></HTML>