<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR><!--[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]--><o:SmartTagType name="time"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="Street"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="address"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="date"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="phone"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="country-region"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Verdana;
}
@font-face {
font-family: Lucida Console;
}
@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; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
H1 {
BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; FONT-WEIGHT: normal; FONT-SIZE: 20pt; BACKGROUND: #e6e6e6; PADDING-BOTTOM: 0cm; MARGIN: 18pt 0cm 6pt; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none; FONT-FAMILY: Verdana; LETTER-SPACING: -0.5pt
}
H2 {
BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; FONT-WEIGHT: normal; FONT-SIZE: 16pt; BACKGROUND: #e6e6e6; PADDING-BOTTOM: 0cm; MARGIN: 12pt 0cm 6pt; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none; FONT-FAMILY: Verdana
}
H3 {
BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; FONT-WEIGHT: normal; FONT-SIZE: 14pt; BACKGROUND: #e6e6e6; PADDING-BOTTOM: 0cm; MARGIN: 6pt 0cm; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none; FONT-FAMILY: Verdana; LETTER-SPACING: -0.25pt
}
P.MsoHeader {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: Tahoma
}
LI.MsoHeader {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: Tahoma
}
DIV.MsoHeader {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: Tahoma
}
P.MsoFooter {
FONT-SIZE: 8pt; MARGIN: 30pt 0cm 0pt; LINE-HEIGHT: 9pt; FONT-FAMILY: Tahoma; LETTER-SPACING: -0.25pt; TEXT-ALIGN: justify
}
LI.MsoFooter {
FONT-SIZE: 8pt; MARGIN: 30pt 0cm 0pt; LINE-HEIGHT: 9pt; FONT-FAMILY: Tahoma; LETTER-SPACING: -0.25pt; TEXT-ALIGN: justify
}
DIV.MsoFooter {
FONT-SIZE: 8pt; MARGIN: 30pt 0cm 0pt; LINE-HEIGHT: 9pt; FONT-FAMILY: Tahoma; LETTER-SPACING: -0.25pt; TEXT-ALIGN: justify
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
P.MsoAcetate {
FONT-SIZE: 8pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoAcetate {
FONT-SIZE: 8pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoAcetate {
FONT-SIZE: 8pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
P.Heading1NotIncluded {
BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; FONT-SIZE: 20pt; BACKGROUND: #e6e6e6; PADDING-BOTTOM: 0cm; MARGIN: 18pt 0cm 6pt; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none; FONT-FAMILY: Verdana; LETTER-SPACING: -0.5pt
}
LI.Heading1NotIncluded {
BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; FONT-SIZE: 20pt; BACKGROUND: #e6e6e6; PADDING-BOTTOM: 0cm; MARGIN: 18pt 0cm 6pt; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none; FONT-FAMILY: Verdana; LETTER-SPACING: -0.5pt
}
DIV.Heading1NotIncluded {
BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; FONT-SIZE: 20pt; BACKGROUND: #e6e6e6; PADDING-BOTTOM: 0cm; MARGIN: 18pt 0cm 6pt; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none; FONT-FAMILY: Verdana; LETTER-SPACING: -0.5pt
}
P.ProposalCoverPage {
FONT-SIZE: 18pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: Arial; TEXT-ALIGN: center
}
LI.ProposalCoverPage {
FONT-SIZE: 18pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: Arial; TEXT-ALIGN: center
}
DIV.ProposalCoverPage {
FONT-SIZE: 18pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: Arial; TEXT-ALIGN: center
}
P.Bullet {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt 36pt; TEXT-INDENT: -18pt; FONT-FAMILY: "Times New Roman"; mso-list: l9 level1 lfo1
}
LI.Bullet {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt 36pt; TEXT-INDENT: -18pt; FONT-FAMILY: "Times New Roman"; mso-list: l9 level1 lfo1
}
DIV.Bullet {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt 36pt; TEXT-INDENT: -18pt; FONT-FAMILY: "Times New Roman"; mso-list: l9 level1 lfo1
}
P.Code {
FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Lucida Console"
}
LI.Code {
FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Lucida Console"
}
DIV.Code {
FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Lucida Console"
}
SPAN.EmailStyle28 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
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 vLink=blue link=blue>
<DIV><SPAN class=431354506-01082003><FONT face=Arial color=#0000ff size=2>Thanks
Adam. Have you ever used it?</FONT></SPAN></DIV>
<DIV><SPAN class=431354506-01082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=431354506-01082003><FONT face=Arial color=#0000ff size=2><!-- 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></P></DIV>
<DIV><BR></DIV></FONT></SPAN>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us 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>Adam Cogan
www.ssw.com.au<BR><B>Sent:</B> 01 August 2003 04:04<BR><B>To:</B> Access
Developers discussion and problem solving; Stuart McLachlan;
"accessd@databaseadvisors.com"@smithers.nildram.co.uk<BR><B>Subject:</B> RE:
[AccessD] HTML Email from Access<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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 face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Adam<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN lang=EN-US
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; 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
w:st="on" Hour="21" Minute="25">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 face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">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: 12pt"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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 face="Courier New"
size=2><SPAN style="FONT-SIZE: 10pt; 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
face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P></DIV></DIV></BLOCKQUOTE></BODY></HTML>