Solved

How to change fill order in merged document

Posted on 2014-09-08
6
64 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
  • 3
  • 2
6 Comments
 
LVL 48

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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 48

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
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 …
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now