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 2004

Tip: Looking for answers? Try searching our database.

Mail Merge issue

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bernie - 27 Jul 2004 14:51 GMT
We have access database which contains records of mail
labels needed to be printed. ABC corp. has 5 entries, XYZ
has 20 entries and DEF Corp has 10 Entries. We have a
query in Access that pulls the records and we use that
query as the datasource for Word mail merge document. Here
is the issue;

When we merge into New Document (or print labels) ABC
corp. shows 6 labels, XYZ shows 18 labels and DEF corp.
has 10 labels.

I have used both <<next record>> and <<next record if not
blank>> (which is what the access query does - removes
blank records) and the result is the same.

The access query shows the correct amount of records!

What is causing some records to be removed and other to
have too many when merged into Word?

We have Office XP loaded on XP Pro.

TIA for any help you guys can provide

Bernie
Peter Jamieson - 27 Jul 2004 23:52 GMT
If you create a catalog/directory type merge with no <<next record.. or
<<next record if>> type fields, do you still see the same problem?

Peter Jamieson

> We have access database which contains records of mail
> labels needed to be printed. ABC corp. has 5 entries, XYZ
[quoted text clipped - 21 lines]
>
> Bernie
Doug Robbins - 28 Jul 2004 02:14 GMT
I don't know what is causing the problem, but why don't you use the label
report wizard in Access?

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> We have access database which contains records of mail
> labels needed to be printed. ABC corp. has 5 entries, XYZ
[quoted text clipped - 21 lines]
>
> Bernie
Bernie - 28 Jul 2004 18:27 GMT
Thanks for the suggestion, I have tried that and same
result. I have also done the merge by using either Excel
or Word as the data source.. same result. I have not come
across solution at this point.  Thanks for the suggestions
>-----Original Message-----
>I don't know what is causing the problem, but why don't you use the label
[quoted text clipped - 27 lines]
>
>.

Rate this thread:






 
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.