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 / July 2006

Tip: Looking for answers? Try searching our database.

In Word 2003 is there a way to tell how many records have been sel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
C2Ranches - 24 Jul 2006 18:38 GMT
In Word 2003 is there a way to tell how many records have been selected?

Example: In Word 2003, when you set up a mailmerge, you select your
database, then the recipients. Is there anyway to get the number of
recipients that have selected? The only why that I see is after the
recipients have been selected to go into edit recipients and select the last
record button. This seems a little clunky though, and causes an extra step. I
was wondering if I am missing something.
Thanks
Peter Jamieson - 24 Jul 2006 20:00 GMT
You are not missing anything - the method you suggest is probably as good as
anything. An alternative is to enable the mail merge toolbar and use the >|
button to preview the last record, but in some cases that can actually be
misleading.

You can write VBA to step through all the records in the merge without
actually merging.

For some types of data source you can use VBA and SQL to count the records,
but only if you have not selected/rejected individual records in the Mail
Merge recipients list.

Peter Jamieson

> In Word 2003 is there a way to tell how many records have been selected?
>
[quoted text clipped - 7 lines]
> was wondering if I am missing something.
> Thanks
C2Ranches - 25 Jul 2006 13:36 GMT
Thank you

> You are not missing anything - the method you suggest is probably as good as
> anything. An alternative is to enable the mail merge toolbar and use the >|
[quoted text clipped - 21 lines]
> > was wondering if I am missing something.
> > Thanks
 
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.