Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merging certain rows of info in database file
In Excel I have 163 rows of data. I need to print envelopes from certain
rows (4, 7, 12, 135, 158, etc.); obviously they are not in numerical order. Thanks in advance for your assistance. -- kc |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merging certain rows of info in database file
If you only do this periodically and are using Word 2002 or 2003, try...
a. enable the Mail merge Toolbar using Word Tools|Customize b. click the Mail Merge recipients icon, deselect all the records (use the appropriate button), select the ones you want (check the appropriate boxes), then save the document before merging. I don't like this stuff much and do not use it myself, but Word is supposed to remember info. about which records you selected. It's just never completely clear exactly what info. it does save in order to do that. The alternative is to create a new column in Excel, put a "Y" in that column in the rows you want, then, in the Mail Merge Recipients box, click the drop-down at the top of that column and select the "Y" records, and save the document. Word is supposed to remember these selections but there are some errors in some versions of Word that make it lose this info (if not the link with the data source). Peter Jamieson "kc" wrote in message ... In Excel I have 163 rows of data. I need to print envelopes from certain rows (4, 7, 12, 135, 158, etc.); obviously they are not in numerical order. Thanks in advance for your assistance. -- kc |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Word merging data into a single document from Database | Mailmerge | |||
Merging Word with a mutiple sheets Excel file | Mailmerge | |||
Merging Works Database file | Mailmerge | |||
mail merging multiple columns with varying number of rows | Mailmerge | |||
Remove Rows from a Table after merging | Mailmerge |