<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Superior Software for Windows Pty Ltd</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="time"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="date"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="phone"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="country-region"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Lucida Console";
panose-1:2 11 6 9 4 5 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h1
{margin-top:18.0pt;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:0cm;
page-break-after:avoid;
background:#E6E6E6;
border:none;
padding:0cm;
font-size:20.0pt;
font-family:Verdana;
letter-spacing:-.5pt;
font-weight:normal;}
h2
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:0cm;
page-break-after:avoid;
background:#E6E6E6;
border:none;
padding:0cm;
font-size:16.0pt;
font-family:Verdana;
font-weight:normal;}
h3
{margin-top:6.0pt;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:0cm;
page-break-after:avoid;
background:#E6E6E6;
border:none;
padding:0cm;
font-size:14.0pt;
font-family:Verdana;
letter-spacing:-.25pt;
font-weight:normal;}
p.MsoHeader, li.MsoHeader, div.MsoHeader
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:Tahoma;}
p.MsoFooter, li.MsoFooter, div.MsoFooter
{margin-top:30.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
text-align:justify;
line-height:9.0pt;
font-size:8.0pt;
font-family:Tahoma;
letter-spacing:-.25pt;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Times New Roman";}
p.Heading1NotIncluded, li.Heading1NotIncluded, div.Heading1NotIncluded
{margin-top:18.0pt;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:0cm;
page-break-after:avoid;
background:#E6E6E6;
border:none;
padding:0cm;
font-size:20.0pt;
font-family:Verdana;
letter-spacing:-.5pt;}
p.ProposalCoverPage, li.ProposalCoverPage, div.ProposalCoverPage
{margin:0cm;
margin-bottom:.0001pt;
text-align:center;
font-size:18.0pt;
font-family:Arial;}
p.Bullet, li.Bullet, div.Bullet
{margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
text-indent:-18.0pt;
mso-list:l9 level1 lfo1;
font-size:12.0pt;
font-family:"Times New Roman";}
p.Code, li.Code, div.Code
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Lucida Console";}
span.EmailStyle28
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
/* Page Definitions */
@page
{mso-endnote-separator:url("cid:header.htm\@01C3574A.FBBA1AA0") es;
mso-endnote-continuation-separator:url("cid:header.htm\@01C3574A.FBBA1AA0") ecs;}
@page Section1
{size:21.0cm 842.0pt;
margin:2.0cm 70.9pt 85.9pt 70.9pt;
mso-footer:url("cid:header.htm\@01C3574A.FBBA1AA0") f1;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:27075359;
mso-list-type:hybrid;
mso-list-template-ids:825399534 1756113632 1308527438 -758115940 -193134772 -973439966 -1521307546 -375853450 -868593400 720955830;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Times New Roman";}
@list l1
{mso-list-id:111019929;
mso-list-type:hybrid;
mso-list-template-ids:1305668248 1519127826 -497099638 750401296 -1166612950 -1839300016 -1135692212 639252636 219964180 1668066840;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Times New Roman";}
@list l2
{mso-list-id:279646738;
mso-list-type:hybrid;
mso-list-template-ids:-28944494 201916417 201916419 201916421 201916417 201916419 201916421 201916417 201916419 201916421;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:18.0pt;
mso-level-number-position:left;
margin-left:18.0pt;
text-indent:-18.0pt;
font-family:Symbol;}
@list l3
{mso-list-id:694698721;
mso-list-type:hybrid;
mso-list-template-ids:-846401974 913215534 -1681871834 -798440072 245245404 -961089052 1472486944 2145403912 896166710 2143469114;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Times New Roman";}
@list l4
{mso-list-id:943076042;
mso-list-type:hybrid;
mso-list-template-ids:1789791552 -1015279024 70938682 -490076422 9889980 271076668 1650491024 -135247250 -696076920 -630684212;}
@list l4:level1
{mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Times New Roman";}
@list l5
{mso-list-id:1250432751;
mso-list-template-ids:582899562;}
@list l5:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6
{mso-list-id:1330448227;
mso-list-type:hybrid;
mso-list-template-ids:688569510 -801842286 161749518 -628063716 -353092258 -970262944 -1946760480 1807221496 730219040 562694082;}
@list l6:level1
{mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Times New Roman";}
@list l6:level2
{mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Times New Roman";}
@list l7
{mso-list-id:1690062304;
mso-list-template-ids:1700196110;}
@list l7:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l8
{mso-list-id:1887596030;
mso-list-template-ids:-397891204;}
@list l8:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l9
{mso-list-id:2041778232;
mso-list-type:hybrid;
mso-list-template-ids:1060303440 -1718030964 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l9:level1
{mso-level-number-format:bullet;
mso-level-style-link:Bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="2" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-AU link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Just FYI if you are looking for a 3<sup>rd</sup>
Party utility to incorporate you can see <a
href="http://www.ssw.com.au/ssw/EmailMergePRO">www.ssw.com.au/ssw/EmailMergePRO</a>
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Adam<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
Andy Lacey [mailto:andy@minstersystems.co.uk] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, 30 July 2003 <st1:time
Minute="25" Hour="21" w:st="on">9:25 PM</st1:time><br>
<b><span style='font-weight:bold'>To:</span></b> Stuart McLachlan;
"accessd@databaseadvisors.com"@smithers.nildram.co.uk<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [AccessD] HTML Email
from Access</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>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>
<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family: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>
</span></font><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'><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 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 href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</a><br>
<a href="http://databaseadvisors.com/mailman/listinfo/accessd" target="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</a><br>
Website: <a href="http://www.databaseadvisors.com/" target="_blank">http://www.databaseadvisors.com</a><br>
<br>
<br>
<br>
<br>
</span></font><font size=2 face=Arial><span style='font-size:10.0pt;font-family:
Arial'><o:p></o:p></span></font></p>
</div>
</div>
</body>
</html>