Sending Multiple Emails

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

Does anyone know any code that will allow me to send a
query to multiple individuals email addresses, but only
specifiying the information relating to their account, as
the query could have up to 500 different account details
on it, thanks in advance
 
I just had this issue this morning for my job..
Before proceeding with the usual Outlook & Access coding, the main issue I found is having the text of the emails pre-written, with fake fields inserted into it. These fake fields could like like this sample
"Dear [CustomerName]
We here at Acme Industries have not gotten your payment of [AmountOverdue]. Please payup now
Respond to this email if you are a deadbeat.

The brackets are only to be used for you to insert (replace) with actual Customer names and Amounts Overdue
The only way I have come up with so far is to have specific coding to read through my pre-written email, find the bracketed text, and replace it with the appropriate data (from a recordset of customer data). So for you 500 emails, my program would sift through the pre-written email text 500 times, every time replacing the Customer Name and Amount Overdue. The final output was unique emails for each recipient

Ti


----- Nick wrote: ----

Does anyone know any code that will allow me to send a
query to multiple individuals email addresses, but only
specifiying the information relating to their account, as
the query could have up to 500 different account details
on it, thanks in advanc
 
Thanks Tim, code you tell me what the usual Access and
Outlook usual coding is as I am falling down at this part
as well

-----Original Message-----
I just had this issue this morning for my job...
Before proceeding with the usual Outlook & Access coding,
Click to expand...
the main issue I found is having the text of the emails
pre-written, with fake fields inserted into it. These
fake fields could like like this sample:
"Dear [CustomerName]:
We here at Acme Industries have not gotten your
Click to expand...
payment of [AmountOverdue]. Please payup now.
Respond to this email if you are a deadbeat."

The brackets are only to be used for you to insert
Click to expand...
(replace) with actual Customer names and Amounts Overdue.
The only way I have come up with so far is to have
Click to expand...
specific coding to read through my pre-written email, find
the bracketed text, and replace it with the appropriate
data (from a recordset of customer data). So for you 500
emails, my program would sift through the pre-written
email text 500 times, every time replacing the Customer
Name and Amount Overdue. The final output was unique
emails for each recipient.
 
Back
Top