Mail Merge, bulk email, address problem (1 Viewer)

Leo_Polla_Psemata

Registered User.
Local time
Today, 09:34
Joined
Mar 24, 2014
Messages
364
Hi
I used today the mail merge through access and send bulk email to 50 clients.

The emails are store in the email field.
Some clients have just one email address
For example
something@something.com

Some other clients have two or more email, for example:
something@something.com;else@something.com;another@something.com

The email was send successfully to these cases with just one email.
Failed to send the email with more than one email which was separated with";"
 

Ranman256

Well-known member
Local time
Today, 12:34
Joined
Apr 9, 2015
Messages
4,339
You can't send email that way. Each email must be a multi records. 1 to many.
But with this you could just parse it ,and just grab the 1st email.

So the query you use to pull the list, parse the 1st email only.
Create a union query...
1 query to pull all emails without a semi...
Where instr(,";")=0

And 2nd query WITH semis....
Where instr([email],";")>0
But in this version ,only pull the 1 email....
Left([email],instr([email],";")-1) as Email

You only need 1 email.
 

Users who are viewing this thread

Top Bottom