Got it :) I had to highlight the whole column and copy it opened a
new workbook and pasted it in hit ctrl F to the find hit the space bar
three times and clicked into the replace with and hit the ok button.
Then I put the data back into the original workbook and did the mail
merge again.
So I guess it was that the field had extra spaces when the data was
created.
Thanks to all that sent me a reply and I look forward to learning more
on this site.
You guys are awesome!
Ramona


--
Rhall
------------------------------------------------------------------------
Rhall's Profile: http://www.excelforum.com/member.php...o&userid=25630
View this thread: http://www.excelforum.com/showthread...hreadid=390428