Solved

How to change fill order in merged document

Posted on 2014-09-08
6
66 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 49

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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
LVL 49

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Photo Albums in PowerPoint Photo Albums are a very useful tool in PowerPoint and allow you quickly add a large number of images. The images can be formatted in a variety of ways so that you are able to create a professional looking presentation v…
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 walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

777 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