Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problems merging with Excel
I am using Word and Excel 2003 for a salary letter mail merge. When I create
a filter on the query options in Word, in some instances, the first record within that filtered data is dropped. For example, if the records I need are in rows 10-25, and I enter the filter data to return those records, row 10 will not merge. Also, the very first record in the entire Excel spreadsheet is always included no matter what I put in the filter options. Any suggestions? I've checked the data source information (Excel file) and everything is correct. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problems merging with Excel
I'm dying on the vine here. I'm willing to try anything at this point. HELP!!
"cew47" wrote: I am using Word and Excel 2003 for a salary letter mail merge. When I create a filter on the query options in Word, in some instances, the first record within that filtered data is dropped. For example, if the records I need are in rows 10-25, and I enter the filter data to return those records, row 10 will not merge. Also, the very first record in the entire Excel spreadsheet is always included no matter what I put in the filter options. Any suggestions? I've checked the data source information (Excel file) and everything is correct. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problems merging with Excel
I have no faith in Word/Mail Merge as a program for the manipulation of data
(such as filtering). If I were doing it, I would copy the Excel data and Paste it into Access as a table and then use a Select Query in Access to do the filtering and use that Query as the data source for a mail merge (though I would probably use an Access Report if that was more suitable). -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "cew47" wrote in message ... I'm dying on the vine here. I'm willing to try anything at this point. HELP!! "cew47" wrote: I am using Word and Excel 2003 for a salary letter mail merge. When I create a filter on the query options in Word, in some instances, the first record within that filtered data is dropped. For example, if the records I need are in rows 10-25, and I enter the filter data to return those records, row 10 will not merge. Also, the very first record in the entire Excel spreadsheet is always included no matter what I put in the filter options. Any suggestions? I've checked the data source information (Excel file) and everything is correct. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems merging lables from Excel to Word | Mailmerge | |||
Still having problems merging with DBF | Mailmerge | |||
Next Record If, problems with merging multiple records | Mailmerge | |||
Anyone having problems merging 9 digit zip codes in Office XP? | Mailmerge | |||
Problems merging many records on a single page | Mailmerge |