Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2006

Tip: Looking for answers? Try searching our database.

merging certain rows of info in database file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kc - 10 Aug 2006 20:31 GMT
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.
Signature

kc

Peter Jamieson - 10 Aug 2006 20:52 GMT
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
> 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.