#1
|
|||
|
|||
Mail Merge
What I'm trying to do I"m not sure what to call it. I have a table and the data I'm merging in comes from Excel. I want the columns to have the Subscription Period value and then the rows below it the fund name with the disbursement amounts for each of the subscription periods. I was sort of able to get the Subscription Periods to go across the columns using Next Record but then I wasn't sure how I go about tying the fund, amounts to the subscription periods. Then I am not sure how I add credits to the bottom.
|
#2
|
||||
|
||||
Your data are not appropriately laid out for a mailmerge. You should be using one row for each record, with a separate column for each field that is to appear in the letter. Each column would have a unique name in the first row and each cell in the output document would have a mergefield corresponding to the relevant column name in Excel.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I"m confused what you are exactly saying?
|
#4
|
||||
|
||||
You should have all the fields for 'Kelly' on a single row in Excel. One column for 'FirstName', separate columns for each 'Subscription Period', separate columns for each 'Fund Name', and separate columns per 'Fund Name' per 'Subscription Period' for each of 'disbursement_netAmount', 'numCourses', & 'SumRegUnits'. Your mailmerge main document would then use mergefields referencing each of these column names for the relevant cells. See attached examples - you'll probably want to change the column names and associated mergefield names.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
I see what you are saying. Now just to figure out how to create a SQL to get the data to come out that way..... do you know SQL? LOL
|
#6
|
||||
|
||||
Your reference to SQL suggests the data are in a database from which the mailmerge should be able to obtain the data directly, without the need to produce the Excel file as an intermediate step. My knowledge of SQL is limited.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Yeah that is possible but in the database the different periods are not specified. The Period relates to the different set of start/end dates.
|
#8
|
||||
|
||||
The alternative would be to extract the data, similar to what you're now doing, but with all the fields for each period on a single line, then use an Excel macro to reformat the data so that the other periods are transferred to the same line.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge is Deleting objects in my header and footer during the merge | bgranzow | Mail Merge | 9 | 06-05-2015 05:03 AM |
Is data merge and mail merge the same thing? | ikearns | Mail Merge | 1 | 09-12-2014 03:53 AM |
Mail merge how to link mail merge field value to a column heading | dsummers | Mail Merge | 1 | 05-08-2014 02:59 PM |
Mail Merge Duplication of address on merge | RICKY | Mail Merge | 1 | 09-26-2012 03:14 PM |
Saving INDV mail merges During the mail merge | sedain121 | Mail Merge | 2 | 10-04-2011 07:52 PM |