Andy Lacey
andy at minstersystems.co.uk
Tue Mar 1 07:57:10 CST 2005
Hi Gustav I had a go at this ages ago. The project never happened so I didn't take it very far but IIRC what I did (and it worked as far as it went) was create an HTML document as my template then, in Access, I read that in line by line as a text file, building up a string, replaced a recognisable bit of text with the required name, then plugged the string into the Outlook email's .HTMLBody. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: Access Developers discussion and problem solving <accessd at databaseadvisors.com> To: accessd at databaseadvisors.com <accessd at databaseadvisors.com> Subject: [AccessD] HTML personalized mass mail Date: 01/03/05 14:35 > > Hi all > > The client wish to move from general mass e-mail (Dear customer ..) in > plain text to personalized e-mail (Dear Mrs. Harkins ..) in HTML > format. > > I know all about getting Access to generate e-mails and have them > mailed but how to create the body of the e-mail in HTML format? Also, > the e-mail must contain a part in plain text which will be shown to > those receivers not having a mail client with HTML reader. > > My thought is to have the client's advertising agency creating a > template with a "field" - some unique search word which I can search for > and replace with the actual customer's name as it carries no purpose to > have the Access app build the e-mail from scratch. > > Has anyone done something similar? > > /gustav > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > > > ________________________________________________ Message sent using UebiMiau 2.7.2