?
Solved

How to change fill order in merged document

Posted on 2014-09-08
6
Medium Priority
?
73 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 52

Accepted Solution

by:
Rgonzo1971 earned 2000 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 52

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
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 …
Suggested Courses

762 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