Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
mail merge please help
Try DataText 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/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge | Excel Discussion (Misc queries) | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
Mail Merge | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) |