If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merge data from Excel into different docs in one Word file
Mail merge from one data soure to a number of different main
In: microsoft.public.word.mailmerge.fields Doug: The Word 2003 file has 16 different mail merge letters with each letter identified with a different letter type code. The Excel 2003 file has data listed on 60 individuals. One column in this Excel file shows the letter type code to be used for each individual's letter. We are trying to figure out how to merge the Excel individual data to the correct Word letter type in one mail merge function. Letter type "E1" for example does not have an individual in the Excel data file with a letter type code "E1" so there would be no records to merge into the "E1" letter; however, there are 2 individuals that should be merging into the "E2" letter, etc. We tried the Insert Word Field "Next Record If" Letter equal to E2, and tried the "Skip Record If" Letter not equal to E2, but neither one is working. It will take the first name on the Excel file which has a letter type ID of "C10" and merge this data into all 16 different letter types, and then go to the next record and merge that data into all 16 deifferent letter types. What are we not doing correctly? "Doug Robbins" wrote: Insert a Next Record field at the point where you want the merge to make use of the next record. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "suew1231" wrote in message ... I am trying to mail merge a number of different letters from one excel spreadsheet. The problem being: If I Copy and paste each doc needed to form one lengthy doc. and mail merge from excel it dosen't change per page. I need each page to reflect a different line from the spreadsheet. Is there any way of doing this besides to brake up the spreadsheet? |
#2
|
|||
|
|||
I don't think that you are doing anything wrong - other than you are trying
to make Word do something of which it is not capable. You should do a series of mailmerges, each one to the relevant letter type with entries in the "letter type code" field being used to filter the records that are merged to each letter type. You can probably use a Skipif field as a crude type of filter, but you will not be able to get away for rerunning the merge for each letter type and setting the appropriate criteria in the Skipif field. The only other way would would be to use visual basic to do the whole thing programmatically. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "sue_w1231" wrote in message ... Mail merge from one data soure to a number of different main In: microsoft.public.word.mailmerge.fields Doug: The Word 2003 file has 16 different mail merge letters with each letter identified with a different letter type code. The Excel 2003 file has data listed on 60 individuals. One column in this Excel file shows the letter type code to be used for each individual's letter. We are trying to figure out how to merge the Excel individual data to the correct Word letter type in one mail merge function. Letter type "E1" for example does not have an individual in the Excel data file with a letter type code "E1" so there would be no records to merge into the "E1" letter; however, there are 2 individuals that should be merging into the "E2" letter, etc. We tried the Insert Word Field "Next Record If" Letter equal to E2, and tried the "Skip Record If" Letter not equal to E2, but neither one is working. It will take the first name on the Excel file which has a letter type ID of "C10" and merge this data into all 16 different letter types, and then go to the next record and merge that data into all 16 deifferent letter types. What are we not doing correctly? "Doug Robbins" wrote: Insert a Next Record field at the point where you want the merge to make use of the next record. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "suew1231" wrote in message ... I am trying to mail merge a number of different letters from one excel spreadsheet. The problem being: If I Copy and paste each doc needed to form one lengthy doc. and mail merge from excel it dosen't change per page. I need each page to reflect a different line from the spreadsheet. Is there any way of doing this besides to brake up the spreadsheet? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |
Automatically Updating Excel Data In Word Doc Inside Excel File | Business Design Architect | General Discussion | 0 | August 29th, 2004 10:55 PM |
Merging MS WORD data into an Excel file | djm | General Discussion | 2 | August 13th, 2004 01:18 PM |
Macro help please: Excel data to word doc | anna-maria | General Discussion | 5 | June 30th, 2004 11:53 PM |