Solved

How to change fill order in merged document

Posted on 2014-09-08
6
71 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 51

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
Industry Leaders: 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 51

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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

724 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