[kim nee]

When I merge from Excel name looks like this
John Smith

and then city state no zip
Marietta GA 3

How do I get the fields together to print correctly and all of the zip?

[Doug Robbins - Word MVP]

How do you have the merge fields organized on the mail merge main document?
Seems like you might have tab spaces between them rather than just a space.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"kim nee" kim wrote in message
...
When I merge from Excel name looks like this
John Smith

and then city state no zip
Marietta GA 3

How do I get the fields together to print correctly and all of the zip?

[kim nee[_2_]]

That worked but is there a way to get rid of "tabs" in the excel doc rather
than doing each field individually
thanks

"Doug Robbins - Word MVP" wrote:

How do you have the merge fields organized on the mail merge main document?
Seems like you might have tab spaces between them rather than just a space.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"kim nee" kim wrote in message
...
When I merge from Excel name looks like this
John Smith

and then city state no zip
Marietta GA 3

How do I get the fields together to print correctly and all of the zip?

[kim nee[_2_]]

never mind I figured it through text to columns

thanks

"Doug Robbins - Word MVP" wrote:

How do you have the merge fields organized on the mail merge main document?
Seems like you might have tab spaces between them rather than just a space.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"kim nee" kim wrote in message
...
When I merge from Excel name looks like this
John Smith

and then city state no zip
Marietta GA 3

How do I get the fields together to print correctly and all of the zip?