Mail merge, and " in the To line, Outlook not happy

[David]

Hello. I am using the Office 2007.
I have a list of contacts in a excell spreadsheet.
When I do a mail merrge, and select to Email out the file Outlook complains
because there is a " at the begining of the list of contacts and a " at the
end.
I do have multiple emial address in a single field of the excell, using ;
between the address.

 

[David]

I should add that it looks like if I do a copy and past from the cell in
excell into a notpad I still get the " " but if I copy from the funtion
line of excell I don't get the "" in notepad.....

So it looks like maybe formating of the copy and past funtionality. Woudl
really like to get a solution for this.

 

[Brian Tillman]

Hello. I am using the Office 2007.
I have a list of contacts in a excell spreadsheet.
When I do a mail merrge, and select to Email out the file Outlook
complains because there is a " at the begining of the list of
contacts and a " at the end.
I do have multiple emial address in a single field of the excell,
using ; between the address.

If you wish to use an Excel spreadsheet as the source of a mail merge,
format the sheet so you have one address per row.

 

[David]

I did that allready using a few commands in excell to pull out the email
address in seperate lines but I still end up wiht the " marks ..... even the
funtion command shows the " as it is pulling the info. Any ideas ?

Thansk