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
>
>