<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2726.2500" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=825291501-31072003><FONT face=Arial color=#0000ff size=2>Your
suggestions and analysis are very provocative. I wonder if your notion can be
abstracted to (in pseudo-code) </FONT></SPAN></DIV>
<DIV><SPAN class=825291501-31072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=825291501-31072003><FONT face=Arial color=#0000ff
size=2> htmlbody = GetFile( </FONT><A
href="http://www.myplace.com/blablabla.htm"><FONT face=Arial
size=2>http://www.myplace.com/blablabla.htm</FONT></A><FONT face=Arial
color=#0000ff size=2> </FONT></SPAN><SPAN class=825291501-31072003><FONT
face=Arial color=#0000ff size=2>)</FONT></SPAN></DIV>
<DIV><SPAN class=825291501-31072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=825291501-31072003><FONT face=Arial color=#0000ff size=2>which
(in language x) would read in said file and assign the string to htmlbody.
Grabbing it from the site would guarantee that all references to pictures,
frames, etc. would be resolved correctly. The text could contain <A
href="file://\\markers\\">\\markers\\</A> and the code could do Replace()s on
them, giving you dynamic text plus pictures &c. Assuming the product table
had a picture reference, couldn't you even plug that in?</FONT></SPAN></DIV>
<DIV><SPAN class=825291501-31072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=825291501-31072003><FONT face=Arial color=#0000ff size=2>Hmmm.
Interesting experiments to perform. </FONT></SPAN></DIV>
<DIV><SPAN class=825291501-31072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=825291501-31072003><FONT face=Arial color=#0000ff size=2>And
while I'm on the recursion thing, why not store all the html as varchar()
columns in a sql database. Instead of literal filenames strewn throughout the
code there could be a PK into the table, load the html and resolve it. IOW, why
not store the site itself in the db, rather than merely populating pages with
sql selects &c? Come to think of it, I recall that's what Sybase PowerDynamo
tries to do. Why hasn't the idea caught on? Are there obvious drawbacks that I'm
missing?</FONT></SPAN></DIV>
<DIV><SPAN class=825291501-31072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=825291501-31072003><FONT face=Arial color=#0000ff
size=2>Arthur</FONT></SPAN></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN class=825291501-31072003><FONT
face=Arial color=#0000ff> </FONT></SPAN></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=825291501-31072003> </SPAN>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Andy
Lacey<BR><B>Sent:</B> July 30, 2003 3:31 PM<BR><B>To:</B> 'Access Developers
discussion and problem solving'<BR><B>Subject:</B> RE: [AccessD] HTML Email from
Access - Progress<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><SPAN class=882001719-30072003><FONT face=Arial color=#0000ff
size=2>Actually Brett has mentioned the key part of this. Everyone else may
have realised, but I didn't, that you need to use Outlook's .HTMLBody rather
than .Body. After that a lot of this becomes straightforward-ish. I should be
able to read any html file (created by Frontpage, Dreamweaver or whatever) a
line at a time, buld up a string and set .HTMLBody to that string. At the same
time I can use Arthur's suggestion for merging data in.</FONT></SPAN></DIV>
<DIV><SPAN class=882001719-30072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=882001719-30072003><FONT face=Arial color=#0000ff size=2>As
for pictures maybe they have to be on the web. I looked at the source of an
html emailshot I got and the pics in there referenced their web-site. And I
think Brett's suggestion below would too. Surely all it's embedding is a link
to a file that has to be available to the recipient. N'est-ce pas? I did the
following. I set strPicPath to a file on my machine, sent the email to myself
and it displayed fine - but if I then renamed the file locally all the email
shows is a placeholder, whether or not the file was also sent as an
attachment. So it does have to be availbale to the recipient. Or am I missing
something Brett?</FONT></SPAN></DIV>
<DIV><SPAN class=882001719-30072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=882001719-30072003><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk/">http://www.minstersystems.co.uk</A>
</FONT></SPAN></P></DIV></BLOCKQUOTE></BODY></HTML>