[J]

I have all of my mail merge information in excel which I use to merge into my
word document. On each row in excel I have three columns with e-mail
addresses. What I'm trying to do is send these e-mails to multiple
individuals for each row of data. When I use the concatenate function to put
the e-mail addresses together in one cell, the second e-mail address is cut
off after the @ symbol. Is there a better way to mail merge to e-mail
sending to multiple individuals?

Formula: =Concatenate(B4&"; "&B5"&"; "&B6)

I receive an error in outlook saying "Your message did not reach some or all
of the intended recipients." However, nobody receives any e-mail.

If I look in the sent items in outlook, I see the e-mail that was being sent
thru the mail merge to e-mail. If I click on the e-mail address in the TO to
open up the E-mail Properties box the E-mail Address has: ;456
(the 2nd e-mail address should be ) and it's being cut off.