[AccessD] HTML Email from Access

MartyConnelly martyconnelly at shaw.ca
Fri Aug 1 07:48:22 CDT 2003


Look at his mailing address. Plus they sponsor a lot of the Access and 
MS SQL Events in Australia

Andy Lacey wrote:

> Thanks Adam. Have you ever used it?
>  
>
> Andy Lacey
> http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/>
>
>
>     -----Original Message-----
>     From: accessd-bounces at databaseadvisors.com
>     [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Adam
>     Cogan www.ssw.com.au
>     Sent: 01 August 2003 04:04
>     To: Access Developers discussion and problem solving; Stuart
>     McLachlan; "accessd at databaseadvisors.com"@smithers.nildram.co.uk
>     Subject: RE: [AccessD] HTML Email from Access
>
>     Just FYI if you are looking for a 3rd Party utility to incorporate
>     you can see www.ssw.com.au/ssw/EmailMergePRO
>     <http://www.ssw.com.au/ssw/EmailMergePRO>
>
>      
>
>     Adam
>
>      
>
>     ------------------------------------------------------------------------
>
>     From: Andy Lacey [mailto:andy at minstersystems.co.uk]
>     Sent: Wednesday, 30 July 2003 9:25 PM
>     To: Stuart McLachlan;
>     "accessd at databaseadvisors.com"@smithers.nildram.co.uk
>     Subject: Re: [AccessD] HTML Email from Access
>
>      
>
>     Hi Stuart
>     Thanks for the reply.
>     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?
>
>     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.
>
>     --
>     Andy Lacey
>     http://www.minstersystems.co.uk
>
>
>     --------- Original Message --------
>     From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
>     To: "Andy Lacey" <andy at minstersystems.co.uk>, "accessd at databaseadvisors.com" <accessd at databaseadvisors.com>
>     Subject: Re: [AccessD] HTML Email from Access
>     Date: 30/07/03 11:03
>
>
>     On 30 Jul 2003 at 11:37, Andy Lacey wrote:
>
>>
>> Morning all
>> Any one have any experience of sending out HTML email-shots from
>> within Access. I already use automation to drive Outlook but have
>> only ever sent text emails. How would I (or more likely the user)
>> format HTML emails? In Word or what? And how would I merge data fom
>> the Access database with it ("Hi Bill" etc) and send them via
>> Outlook? Any ideas? Anyone doing it already? Any guidance would be
>> gratefully received.
>>
>
>     I do it in a number of different ways.
>
>     I have a small PB application which interrogates a Contact list and
>     sends out to everyone with a certain "category" in the the contacts
>     list. It is designed to compose the html mail in Outlook which is
>     then saved to a HTML file.
>
>     I've also done it by creating a report and using Docmd.SendObject to
>     each one in turn with a single page report output as HTML.
>
>     Email me off-list with more info on exactly what you are trying to do
>     and I'll fire something through to you.
>
>     (I do it under protest for a client , but I personally have an
>     aversion to html emails <g>)
>
>
>     --
>     Lexacorp Ltd
>     http://www.lexacorp.com.pg <http://www.lexacorp.com.pg/>
>     Information Technology Consultancy, Software Development,System
>     Support.
>
>
>
>     _______________________________________________
>     AccessD mailing list
>     AccessD at databaseadvisors.com <mailto:AccessD at databaseadvisors.com>
>     http://databaseadvisors.com/mailman/listinfo/accessd
>     Website: http://www.databaseadvisors.com
>     <http://www.databaseadvisors.com/>
>
>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>  
>




More information about the AccessD mailing list