Originally Posted by
Ajax
there are plenty of threads on this and other forums about sending emails - so I'll concentrate on the personalisation.
There are two basic methods 'build' and 'template'
Presupposing you have in your client table a field called 'salutation' (might be populated with Joe or Mr Smith)
In your email table, lets suppose you have a message
"We are pleased to report that nothing has happened in the last week"
To build you would fetch both records and concatenate a string, something like
msg="Dear " & Salutation & "," & vbcrlf & vbcrlf & emailmessage
or for a template, your email table would contain
"Dear [Salutation],
We are pleased to report that nothing has happened in the last week"
and as before, fetch both records and replace [Salutation] in the emailmessage
msg=replace(emailmessage,"[Salutation]",salutation)
with regards track who has had what email, you need a tracking table with something like
ClientID
MessageID
DateSent
and as part of the code sending the email, include code to insert a record into this table.
If you are going to do this - 'I want to be able to edit the mail to make the standard mail more personal.' - you may also want to store the full email text as well.