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