Home |
Search |
Today's Posts |
#1
|
|||
|
|||
mail merge
I know this is probably a really silly(stupid) question..... I need to do a mail merge to make labels from an excel file. Sounds simple enough, but when I get to the prompt in the wizard to select files to merge i keep losing the the third line(which would be the city, state and zip). It also drops row 1. Can anyone help me figure this out? Thanks! MC -- mariachilds ------------------------------------------------------------------------ mariachilds's Profile: http://www.excelforum.com/member.php...o&userid=26434 View this thread: http://www.excelforum.com/showthread...hreadid=397053 |
#2
|
|||
|
|||
Don't know what you mean with your first query, but the first row of
your data should be the field name (e.g., First Name, Last Name, Address1, Address2, City, State, Zip,....) In article , mariachilds wrote: I know this is probably a really silly(stupid) question..... I need to do a mail merge to make labels from an excel file. Sounds simple enough, but when I get to the prompt in the wizard to select files to merge i keep losing the the third line(which would be the city, state and zip). It also drops row 1. Can anyone help me figure this out? |
#3
|
|||
|
|||
Hi Maria,
If the all of the data for a label is not on one row then you must make it so. http://www.mvps.org/dmcritchie/excel/snakecol.htm If you have your data for each label and are losing an entire column of data, or the content does not match your worksheet, make sure that you have the worksheet as the first worksheet (leftmost tab). http://www.mvps.org/dmcritchie/excel/mailmerg.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "JE McGimpsey" wrote in message ... Don't know what you mean with your first query, but the first row of your data should be the field name (e.g., First Name, Last Name, Address1, Address2, City, State, Zip,....) In article , mariachilds wrote: I know this is probably a really silly(stupid) question..... I need to do a mail merge to make labels from an excel file. Sounds simple enough, but when I get to the prompt in the wizard to select files to merge i keep losing the the third line(which would be the city, state and zip). It also drops row 1. Can anyone help me figure this out? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form to Mail Merge | New Users to Excel | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
Serious Mail Merge Problem | Excel Discussion (Misc queries) | |||
mail merge from excel | Excel Discussion (Misc queries) | |||
Extract Data for Mail Merge | Excel Discussion (Misc queries) |