#1
|
|||
|
|||
Desperate for Logic Help
I am looking for help in finding a way to accomplish the following task involving the merging of data from an Excel database to a Word document using the mail merge feature.
In my Excel database, I have columns (fields) related to 8 services available to a particular record. These 8 services can be shared amongst 2 or more crews. A Word merge document is created for each crew, listing each record and the fields associated with that data, including any of the 8 services that crew may be responsible for. However, the mail merge document is capable of providing only 4 services for each crew. Consider the following Excel data: r1_crew = hpe r2_crew = hpe r3_crew = hpe r4_crew = hpl r5_crew = hpl r6_crew = cul r7_crew = "" r8_crew = "" There are three different crews responsible for providing the up to 8 services. Each crew will have it's own mail mail document created, for which the services they are responsible for will be documented. However, there are only 4 fields available in the mail merge document... r1_crew r2_crew r3_crew r4_crew But I don't don't how to ensure that the three crews are given their services since the report only covers r1_crew through r4_crew, and not r5_crew through r_8_crew. The reports need to report the following Report: hpe {MMfield : r1_crew} = r1_crew {MMfield : r2_crew} = r2_crew {MMfield : r3_crew} = r3_crew {MMfield : r4_crew} = "" Report: hpl {MMfield : r1_crew} = r4_crew {MMfield : r2_crew} = r5_crew {MMfield : r3_crew} = "" {MMfield : r4_crew} = "" Report: cul {MMfield : r1_crew} = r6_crew {MMfield : r2_crew} = "" {MMfield : r3_crew} = "" {MMfield : r4_crew} = "" in other words, atthough r4_crew represent he fourth service overall, it is the first service for HPL, and r6_crew is the first service for CUL. The shared mail merge document have only fields representing r1_crew through r4_crew, so really, only the HPE's services will be merged. I hope I've provided a clear enough explanation of what I hope to accomplish. It was difficult to put in into words. I am unsure whether the assignment of the different services needs to reassigned somehow in excel, or it it can be done at the point of the mail merge. |
#2
|
||||
|
||||
It's not clear whether your r1_crew - r8_crew references are fields or records. That makes a big difference as to how the data might be processed. It would be helpful if you could post both a workbook containing some sample data and the mailmerge main document (delete anything sensitive).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
As I look further into my project scope, I've come to realize that this will not be possible. But thanks for the support!!!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Text allignment - desperate! | Ctonning | Word | 5 | 01-13-2016 05:11 AM |
Issue with Index and Match logic | vegasbound365 | Excel | 2 | 12-04-2014 09:02 AM |
ms project 2010 calculating logic | ketanco | Project | 2 | 06-15-2014 09:03 AM |
What logic does P.P. use to move elements on theme change? | Malcom | PowerPoint | 2 | 05-24-2013 02:55 AM |
How to stop "replace"'ing new words (in desperate need of advice) | bme081 | Word | 6 | 11-02-2009 05:57 AM |