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 / March 2004

Tip: Looking for answers? Try searching our database.

Next Record problems, please help..!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul Newton - 15 Mar 2004 15:25 GMT
I have a big problem..

[Background]
I have created 6 mail merge documents each consisting of 2 columns x 3
rows of vouchers, these are to create pages for a Car Dealer's Voucher
Book.

The Fields are:
.Customer Number
.Customer Name
.Customer Licence Plate Number

The data source is an Excel spreadsheet.

Each document is made up of just the 1 table with many rows and
columns that position the fields to suit.

The pages that will be generated will be printed on to pre-printed
documents, so hours have been spent adjusting the rows etc. to suit.

My Problem is this....

I have added the <<Next Record >> identifyiers just before each
voucher, but each voucher is not coming out unique.

For example, The first Customer Name on the first voucher is ok, but
the Licence Plate number is for the next customer in the database.

This is the pattern for the entire document, e.g. Customer Name is ok
on each voucher, but the Licence Plates are wrong, both columns have
the same Licence Plate number, they should be different.

I have tried to create some test merge docs on their own by creating a
'master' table of 2x3 structure, then inserting a new table within
this with the rows/cols that I need and this works, each 'voucher' is
then unique as required.

To change all 6 docs to do this is a huge job, and a visit to the
customer will be needed to test all the positioning again.

So, I am asking, is there an easy answer to this?

Many thanks for any help.

Paul Newton
Charles Kenyon - 15 Mar 2004 18:25 GMT
This is a guess, and only a guess.

Could it be that the tables that are not working are either drawn or nested
tables rather than created tables? I can conceive of this throwing off which
field or merge command is reached in what order. I haven't tested this, just
tossing it out.
Signature


Charles Kenyon

See the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> I have a big problem..
>
[quoted text clipped - 41 lines]
>
> Paul Newton
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 16 Mar 2004 09:47 GMT
I would be looking very carefully at the placement of the <<Next Record>>
field

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>I have a big problem..
>
[quoted text clipped - 41 lines]
>
> Paul Newton
Paul Newton - 16 Mar 2004 18:06 GMT
Firstly, thanks to all who responed to my query.

Charles, no the tables were created with Table->Insert->Table...

Doug, I have moved the <<Next Record>> field all over the place, with
differing results apart from the correct one.

I have actually got it to work now by getting rid of all the rows in
the table(s) and just putting the fields in the one row, this seems to
work, it's just that I have a lot of rework to do.

Thanks again..

Paul Newton

> I would be looking very carefully at the placement of the <<Next Record>>
> field
[quoted text clipped - 44 lines]
> >
> > Paul Newton
 
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.