Solved

How to change fill order in merged document

Posted on 2014-09-08
6
70 Views
Last Modified: 2015-02-18
Hello,

I created a merged word document that creates a list of addresses in a form letter.  It's working fine, however the user now wants the addresses to be listed in alphabetical order down one column then continuing to the next column for a total of three columns.  The source of the data is from an access database query via a DSN.  I have been trying to figure out how to do this but I'm not sure if it is possible to change the fill order.  I've attached the current document where ther addresses are being printed left to right in alphabetical order.
Full-Tree-Service-List.docx
0
Comment
Question by:chtullu135
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40310356
Hi,

You could create a field in you query to be able to sort the data as you want

Regards
0
 

Author Comment

by:chtullu135
ID: 40310592
I was not referring to the sort order, I was referring to the fill order.  The labels are being printed left to right in alphabetical order.  I want to print then top to bottom in alphabetical order
0
 
LVL 24

Expert Comment

by:SunBow
ID: 40310762
Consider dividing ('break'-ing) the relevant area into Sections, 3 (vertical) sections. It appears that what you want is something more like index to document than multi-column table.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 50

Expert Comment

by:Rgonzo1971
ID: 40311358
I do not think that it is posible to change the fill order that's why I was recommending this workaround

Regards
0
 

Author Comment

by:chtullu135
ID: 40312261
I found the solution and will post it
0
 

Author Closing Comment

by:chtullu135
ID: 40618120
Thanks for the help
0

Featured Post

Building an interactive eFuture classroom

Watch and learn how ATEN provided a total control system solution including seamless switching matrix switch, HDBaseT extenders, PDU, lighting control to build an interactive eFuture classroom.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question