Good Morning,
I am helping a user who is experiencing the following mail merge issue. She has a letter that is written in Word 2010 32bit. She has turned it into a mail merge that pulls data from an Access database. The merge populates some user information and then e-mails the user at an e-mail address in the database. It e-mails out as an HTML e-mail through Outlook 2010 which is setup to use an Office 365 e-mail account.

Until last week this was working correctly but now only e-mails about 3/4 of the database table. I've done a number of tests and it seems that the same group of users get skipped every time and never even reach Outlook's outbox. No error message is given. Here is a list of things I have tried, any help would be greatly appreciated.

- I completed the mail merge to print instead of to e-mail and all users merge correctly.
- I verified that the e-mail addresses in the database could be e-mailed manually.
- I had some of the bad entries hand typed out in a new row from scratch with no copy or pasting to verify that there were no extra character and/or spaces in the original row. It still did not work.
- I had several rows copied into an Excel sheet and then used the Excel sheet as the data source and the same entries succeeded and failed as before.
- I checked for similarities between the the bad e-mail addresses that might cause this issues (such as long addresses or periods in the address) but there were no similarities, the were all very different.
- I did all updates on Office and then did a repair of the installation.
- Thinking that maybe there was some error in how the mail merge was moving to each consecutive record, I added a <<Next Record>> at the end of the document to see if this would for the merge to go to each record.
- I replaced the e-mail addresses in the table so that every record had my e-mail address and it worked. I received every e-mail.
- I replaced the SMTP server in Outlook so that it went out through an inhouse smtp server so that I could capture the logs and found that the bad entries even try to send out.

It seems like these specific e-mail addresses are having an issue being passed to Outlook but there is nothing remarkable or unusual about the addresses. Any ideas?

Thanks,
Ryan