[AccessD] HTML personalized mass mail

Hi Andy

OK, in that way the file for the body - including pictures - can have
any size.

The only issue I can see at the moment is, that "foreign" characters
(non US ASCII) are encoded in HTML.
How would I do that encoding? It is relevant as names here often
contain strange characters.

Or would it be enough just to specify the character set, which is
"ISO-8859-1", as the default for the document? Then any special
character can be "hardcoded" in the body.

/gustav

>>> andy at minstersystems.co.uk 01-03-2005 14:57:10 >>>
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