mail merge output
 

I have a problem with a source file in excel for my mail merge.

the field in excel has all lines of the address split by a / sign... there
are three in each cell e.g. anyhouse/anytown/anycounty/anyzipcode

how do i split the data out so i can produce my mailmerge

any ideas please

mail merge output
 

See reply to "How do I split addresses(city, state,zip)?" 13 questions ago
dated 9/2/2008 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

"pj finsol" wrote:

I have a problem with a source file in excel for my mail merge.

the field in excel has all lines of the address split by a / sign... there
are three in each cell e.g. anyhouse/anytown/anycounty/anyzipcode

how do i split the data out so i can produce my mailmerge

any ideas please