<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi Andy</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I', just completing something very similar to
this. It sends the emails via Outlook and I have a page for adding
attachments etc also. I'm still fine tuning it, but if you would like to
see where I'm at I'd be happy to send you it (I'll be away for a day so there'll
be a delay). Let me know.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Cheers</FONT></DIV>
<DIV><FONT face=Arial size=2>Selina</FONT></DIV>
<DIV>
<HR align=center width=400 color=#df18b7 noShade>
<TABLE cellSpacing=0 cellPadding=0 width=400 align=center border=0>
<TBODY>
<TR>
<TD vAlign=top width=10> </TD>
<TD vAlign=top width=188><FONT
face="Verdana, Arial, Helvetica, sans-serif" size=1><STRONG><FONT
color=#1a51c0>Selina Iddon </FONT><BR></STRONG><A
href="mailto:selina@easydatabases.com.au"><FONT
color=#000000>selina@easydatabases.com.au</FONT></A><BR></FONT></TD>
<TD vAlign=top width=152><FONT
face="Verdana, Arial, Helvetica, sans-serif" size=1>Ph: 0414 225
265<STRONG><BR></STRONG>Easy Access Databases </FONT></TD>
<TD vAlign=top width=50>
<DIV align=center><IMG height=33
src="http://www.digitalfunk.net/Clients/EAD/email_use/small_logo.jpg"
width=33></DIV></TD></TR></TBODY></TABLE>
<DIV align=left></DIV></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=andy@minstersystems.co.uk
href="mailto:andy@minstersystems.co.uk">Andy Lacey</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=stuart@lexacorp.com.pg
href="mailto:stuart@lexacorp.com.pg">Stuart McLachlan</A> ; <A
title='"accessd@databaseadvisors.com"@smithers.nildram.co.uk'
href='mailto:accessd@databaseadvisors.com"@smithers.nildram.co.uk'>"accessd@databaseadvisors.com"@smithers.nildram.co.uk</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, July 30, 2003 9:25
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] HTML Email from
Access</DIV>
<DIV><BR></DIV>Hi Stuart<BR>Thanks for the reply.<BR>I'm about to visit a
potential new client who is looking to replace an off-the-shelf contact
management system withan Access app. Good news for me I hope. Anyway one of
the requirements is to be able to prepare HTML emails (text and pics and
anything else I guess) with, in effect, field placemarks (e.g. [CustomerName]
or whatever). It then has to do an "emailmerge" between the HTML and the data
and send to all on his list. Does that make sense? What do you
think?<BR><BR>I've kept this on-list for now as it better explains (I hope)
what I'm trying to do and there may be others out there who can help or want
to see where the discussion leads.<BR><BR>--<BR>Andy
Lacey<BR>http://www.minstersystems.co.uk<BR><BR><BR><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">--------- Original Message --------<BR>From:
"Stuart McLachlan" <stuart@lexacorp.com.pg><BR>To: "Andy Lacey"
<andy@minstersystems.co.uk>, "accessd@databaseadvisors.com"
<accessd@databaseadvisors.com><BR>Subject: Re: [AccessD] HTML Email
from Access<BR>Date: 30/07/03 11:03<BR><BR><FONT face="Courier New"
size=2><BR>On 30 Jul 2003 at 11:37, Andy Lacey wrote:<BR><BR>><BR>>
Morning all<BR>> Any one have any experience of sending out HTML
email-shots from<BR>> within Access. I already use automation to drive
Outlook but have<BR>> only ever sent text emails. How would I (or more
likely the user)<BR>> format HTML emails? In Word or what? And how would
I merge data fom<BR>> the Access database with it ("Hi Bill" etc) and
send them via<BR>> Outlook? Any ideas? Anyone doing it already? Any
guidance would be<BR>> gratefully received.<BR>><BR><BR>I do it in a
number of different ways.<BR><BR>I have a small PB application which
interrogates a Contact list and<BR>sends out to everyone with a certain
"category" in the the contacts<BR>list. It is designed to compose the html
mail in Outlook which is<BR>then saved to a HTML file.<BR><BR>I've also done
it by creating a report and using Docmd.SendObject to<BR>each one in turn
with a single page report output as HTML.<BR><BR>Email me off-list with more
info on exactly what you are trying to do<BR>and I'll fire something through
to you.<BR><BR>(I do it under protest for a client , but I personally have
an<BR>aversion to html emails <g>)<BR><BR><BR>--<BR>Lexacorp Ltd<BR><A
class=autolink href="http://www.lexacorp.com.pg/"
target=_blank>http://www.lexacorp.com.pg</A><BR>Information Technology
Consultancy, Software
Development,System<BR>Support.<BR><BR><BR><BR>_______________________________________________<BR>AccessD
mailing list<BR><A class=autolink
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
class=autolink href="http://databaseadvisors.com/mailman/listinfo/accessd"
target=_blank>http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A class=autolink href="http://www.databaseadvisors.com/"
target=_blank>http://www.databaseadvisors.com</A><BR><BR><BR><BR><BR><BR></FONT></DIV></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>