 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2005I have a db excel I want to mail merge 6 envlopes in word
I have a data base in excel I want to mail merge envlopes in word 2000.I can not seem to pick out a few people that I want to send to from db.I either can do 1 or all.There must be a way.In word 2002 I can pick individual name by putting a check in db.Am I doing some thing wrong or does word 2000 not do this ? Thanks in advance for any help Jean On the Merge dialog box select "Query Options...", on the Query Options dialog box select the Field, under Comparison select "Equal To" and in the Compare to box type the person's name as it appears in the field. On the next line select in the first box select "Or" and repeat the process used in the first line. You can do up to 6 queries. Note: you need to select "Or" at the beginning of the 2nd thru 6th lines so that when performing each query, the query only has to meet one condition. If you select "And," the query would need to meet all the conditions of the query. > I have a data base in excel I want to mail merge envlopes in word 2000.I can > not seem to pick out a few people that I want to send to from db.I either > can do 1 or all.There must be a way.In word 2002 I can pick individual name > by putting a check in db.Am I doing some thing wrong or does word 2000 not do > this ? Thanks in advance for any help Jean Yes but that is way to time consuming.Is there a way just to select the name in the excel db so when you merge it just merges these names, Thank you for you help.It just take so long every day to send out 10 sometimes more.I just thought it would be easier > On the Merge dialog box select "Query Options...", on the Query Options > dialog box select the Field, under Comparison select "Equal To" and in the [quoted text clipped - 12 lines] > > by putting a check in db.Am I doing some thing wrong or does word 2000 not do > > this ? Thanks in advance for any help Jean You could set up a new field called "Send" in which you place, say, an "x" and then in yous Query options choose the field (Send), under Comparison select "Equal to" and in Compare to: type "x" (exclude the quotes). This is not as easy as in later versions of Word/Excel, but would save some time. > Yes but that is way to time consuming.Is there a way just to select the name > in the excel db so when you merge it just merges these names, Thank you for [quoted text clipped - 17 lines] > > > by putting a check in db.Am I doing some thing wrong or does word 2000 not do > > > this ? Thanks in advance for any help Jean Thank you ,What is the program I need to make this easy > You could set up a new field called "Send" in which you place, say, an "x" > and then in yous Query options choose the field (Send), under Comparison [quoted text clipped - 22 lines] > > > > by putting a check in db.Am I doing some thing wrong or does word 2000 not do > > > > this ? Thanks in advance for any help Jean I now use Office 2003 and it works much better with merges (in much the same way as Word 2002). I'd suggest you upgrade if at all possible. > Thank you ,What is the program I need to make this easy > [quoted text clipped - 24 lines] > > > > > by putting a check in db.Am I doing some thing wrong or does word 2000 not do > > > > > this ? Thanks in advance for any help Jean There is no need to upgrade for Word 2000. In fact, most people find doing mail merge with Word XP or 2003 "out of the box" to be quite confusing. In your case, when editing the Mail Merge main document, select the Word Fields pull-down and insert a Next Record If field BEFORE any other merge fields in the main document and then select the appropriate Field (the field named "Send" as SVC suggested) and set the criteria to "x" if you also used what he suggested.  SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Thank you ,What is the program I need to make this easy > [quoted text clipped - 40 lines] >> > > > 2000 not do >> > > > this ? Thanks in advance for any help Jean Microsoft changed the way merges work in version 2002 (retained for the current version). Some things were improved, others were not. In Word 2000, you have the option to set a query from the mail merge helper. In Word 2002/3 you can check off from a list of records. An answer may be to import the address list into an Outlook contacts list. You can then merge from Outlook which makes it easy to pick records - http://www.gmayor.com/mailmerge_from_outlook.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I have a data base in excel I want to mail merge envelopes in word > 2000.I can not seem to pick out a few people that I want to send to > from db.I either can do 1 or all.There must be a way.In word 2002 I > can pick individual name by putting a check in db.Am I doing some > thing wrong or does word 2000 not do this ? Thanks in advance for any > help Jean |
Reply to this Message |
 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.