[AccessD] HTML personalized mass mail

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