Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the tab order for text form fields in Word? | Microsoft Word Help | |||
How do I set max field length of merged fields? | Mailmerge | |||
How do I change the order of the FILLIN field prompts? | Page Layout | |||
Field code change | Microsoft Word Help | |||
Can't change font size/type on merged fields | Mailmerge |