Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
CJ_Printer CJ_Printer is offline
external usenet poster
 
Posts: 1
Default Is there VB or Field Code to change the order of merged fields?


I work in a hospital in house print shop. We have been doing merges for
years using Word with Excel for the data source.

On orders that will be produced more than one to a sheet (ie. 4 sheets
4.25 X 5.5 on 1 sheet 8.5 X 11) we have historically produced an Excel
file containing a set of columns for each set of merged data on per
card. We have done this so each stack after cutting will be in the
correct sequence. (First merged sheet through last merged sheet in one
stack, picking up with the top of the next stack, etc...)

This brings me to our question. Is there a more elegant way, either in
Word or Excel, to accomplish this without having to split the data
source into sets of columns for each set of merged data?

It's really not that big of a deal with small data sources, but when
you get into tens of thousands of names it gets complicated FAST.
Imagine 90000+ names divided into 16 sets of columns. Each set
containing a prefix, first name, middle name, last name, suffix,
credentials, address, city, state, and zip. Then throw in the fact
that about half of the prefix, middle name, suffix, and credential
fields are blank, and you start getting into some pretty difficult
coding.

We're fairly comfortable with our current process, however it's awfully
time intensive.

We are just trying to figure out if we are missing some field code or
VB script that could make our lives easier. Any help would be GREATLY
appreciated.

Thanks in advance!




--
CJ_Printer
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the tab order for text form fields in Word? copperkid Microsoft Word Help 1 August 1st 06 10:24 PM
How do I set max field length of merged fields? chiefcook Mailmerge 1 September 25th 05 07:05 AM
How do I change the order of the FILLIN field prompts? Unpaved313 Page Layout 1 March 28th 05 08:41 PM
Field code change Rory Brady Microsoft Word Help 1 March 17th 05 10:21 PM
Can't change font size/type on merged fields Jerry Crosby Mailmerge 1 March 1st 05 07:04 AM


All times are GMT +1. The time now is 10:34 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"