Software

Ask something
Question Locked

Bad Mail Address Error in Mail Merge

0 helpful
3 replies

by chetanr1shah

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

I am using Mail merge to send mails. Each cell of Excel sheet consist of 25mail IDs seperated by Commas.When I use this excel sheet "I am getting error Record Consistof Bad Mail Address".I have tried all the combination semicolon,space and comma, still error persists
However if the cell consist of only one record it works fine.
As my Mail Size is large and hence I want to club 25 Email Ids in one mail
Please help.

3 replies

by thumbsup2

Put one email address per cell in the spreadsheet. Then, during the merge, only select 25 recipients at a time.

by mpace

Why don't you put individual email address in different rows and merge them that way. If you are wanting to put all the emails addresses in one email, then copy and paste into outlook. If you have a bad address (i.e bad syntax in the email address, you will have to fix that or delete it for the email to go).

This discussion is closed to new replies.