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 2004

Tip: Looking for answers? Try searching our database.

Merge doesn't display data in correct order

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lynn Scott - 20 Aug 2004 20:51 GMT
I am making a horse sale catalouge in word using data
from an Access database. I would like to display 4 horses
to a page. I can get 4 horses to a page but I cannot get
them in the correct order.

I would like HOrse 1 in top left corner of page, horse 2
in top right corner of page, horse 3 in lower left corner
of page, horse 4 in lower right corner of page.

Right now Horse 1 is in top left as desired but horse 2
is below it in lower left corner. Horse 3 is then
displayed in top right corner. Horse 4 in bottom right.

Help please. I have been working onthis for hours and
just cannot figure it out.

Thanks,
Lynn
Doug Robbins - 20 Aug 2004 23:39 GMT
As your data is in Access, why bother with Word.  Use the Report Label
Wizard in Access and at the end of the Wizard process, use the option to
modify the report design and then from the Access File menu, selectse Page
Setup and go to the Columns tab and in the Column layout section of the
dialog, you can choose between Across and then Down or Down and then Across.

If you do want to do it with Word, you should be using a Catalog or
Directory Type mailmerge with merge fields set up in a table with two sets
of merge fields accross, with a <<Next Record>> field before the first merge
field in the second set of fields.  When you execute this merge, you should
get want you want, but in that you have to set up two sets of fields, it's
twice as much work as doing it 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

>I am making a horse sale catalouge in word using data
> from an Access database. I would like to display 4 horses
[quoted text clipped - 14 lines]
> Thanks,
> Lynn
Graham Mayor - 21 Aug 2004 07:51 GMT
I'd setup a table without borders and create a label merge using the table
as the 'labels'
You will probably find http://www.gmayor.com/mail_merge_graphics.htm and
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm useful.
Merge to a new document and add the supplementary information you require on
the page.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am making a horse sale catalouge in word using data
> from an Access database. I would like to display 4 horses
[quoted text clipped - 14 lines]
> Thanks,
> Lynn

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.