mail merge please help   

I want to do a mail merge. 
For this, each line of the address is supposed to be on one line of Excel 
(e.g address 1, address  2). 
However, the entire address for each (person to be mailed) has been put in 
one cell, on one row.  
Is there a way to do a mailmerge or do I need to put each line of the 
address into a different row?  IF so, how can I do this without wading 
through every single line? 
Most of the addresses have commas between the line of address, eg Richard 
Hart, 2 Letsby Avenue, .. if that helps.

date: Tue, 29 Jul 2008 05:52:01 -0700   author:   Leon

Re: mail merge please help   

Try Data>Text to Columns delimited by Comma and see what you get.

Elements of the addresses go into separate columns with a title like

Name   Address   City   State   Zip

See these sites for help on mailmerge in Word with Excel as data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm 

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm 

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm

Note.........if you give your table a defined name you don't have to have
the worksheet first in the workbook.


Gord Dibben  MS Excel MVP


On Tue, 29 Jul 2008 05:52:01 -0700, Leon 
wrote:

>I want to do a mail merge. 
>For this, each line of the address is supposed to be on one line of Excel 
>(e.g address 1, address  2). 
>However, the entire address for each (person to be mailed) has been put in 
>one cell, on one row.  
>Is there a way to do a mailmerge or do I need to put each line of the 
>address into a different row?  IF so, how can I do this without wading 
>through every single line? 
>Most of the addresses have commas between the line of address, eg Richard 
>Hart, 2 Letsby Avenue, .. if that helps.

date: Tue, 29 Jul 2008 10:11:26 -0700   author:   Gord Dibben gorddibbATshawDOTca