Mail Merge, bulk email, address problem

[Leo_Polla_Psemata]

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]

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.

 

[Leo_Polla_Psemata]

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.[/QUOTE]


Hi, thanks for the input
I use this bit in my query
Email: Left([addr],InStr([addr],";")-1)
and I pull successfully the first email

So, if the field [addr] contains two emails (or three) , how can I pull out the second email which is lying between first ";" and second";" (or pull out a third email) ?
Example addr:abc1@dot.com; abc2@dot.com; abc3@dot.com
pull out
emailA:abc1@dot.com
emailB:abc2@dot.com
emailC:abc3@dot.com

 

[Gasman]

Use the split function?

https://www.techonthenet.com/access/functions/string/split.php