Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I do mail merge using filtered data from excel
Office 97 I want to create mailing labels from excel worksheet. I have
AutoFilter turned on and will use it to select the recipients (which will vary each time). I want to automate this procedure, at least the mail merge portion. I would like to eventually set up a macro to print the labels, but I can't get it to work manually yet. My mail merge will not let me select the Filtered data. I have even copied to filtered sheet to another sheet. Any help would be appreciated. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I do mail merge using filtered data from excel
Hi ?B?UkVWQQ==?=,
Office 97 I want to create mailing labels from excel worksheet. I have AutoFilter turned on and will use it to select the recipients (which will vary each time). I want to automate this procedure, at least the mail merge portion. I would like to eventually set up a macro to print the labels, but I can't get it to work manually yet. My mail merge will not let me select the Filtered data. I have even copied to filtered sheet to another sheet. Any help would be appreciated. Well, if you set a filter in Excel, then you have to set "Query Options" in the mail merge document. Choose a field which definitely has an entry in every record (row). Then select the comparison "is not blank". That will drop the records that the filter is hiding (but which Word still picks up, with no field content). Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I do mail merge using filtered data from excel
I did what you said about the No Blanks, BUT it is still bringing in ALL of the
rows in the worksheet. I am using the AutoFilter feature. Do I have to Name the filtered area or something? In the mail merge I am Confirming Data Source and must use the Microsoft Excel Worksheet via Converter (*.xls,*xlw) to see my data. When the Open Worksheet window appears, I can choose the CORRECT WORKSHEET, BUT the Name or Cell Range says only ENTIRE WORKSHEET. "Cindy M -WordMVP-" wrote: Hi ?B?UkVWQQ==?=, Office 97 I want to create mailing labels from excel worksheet. I have AutoFilter turned on and will use it to select the recipients (which will vary each time). I want to automate this procedure, at least the mail merge portion. I would like to eventually set up a macro to print the labels, but I can't get it to work manually yet. My mail merge will not let me select the Filtered data. I have even copied to filtered sheet to another sheet. Any help would be appreciated. Well, if you set a filter in Excel, then you have to set "Query Options" in the mail merge document. Choose a field which definitely has an entry in every record (row). Then select the comparison "is not blank". That will drop the records that the filter is hiding (but which Word still picks up, with no field content). Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I do mail merge using filtered data from excel
Hi ?B?UkVWQQ==?=,
I did what you said about the No Blanks, BUT it is still bringing in ALL of the rows in the worksheet. I am using the AutoFilter feature. Do I have to Name the filtered area or something? In the mail merge I am Confirming Data Source and must use the Microsoft Excel Worksheet via Converter (*.xls,*xlw) to see my data. When the Open Worksheet window appears, I can choose the CORRECT WORKSHEET, BUT the Name or Cell Range says only ENTIRE WORKSHEET. Ah. The problem is with using "Worksheet via converter". Since the filtering takes place ONLY in the Excel user interface, it Word can only "see" the filter when you use a DDE connection. The converter makes a copy of the worksheet DATA (nothing in the UI) and passes that as a virtual file to Word, in memory. If you want to use the converter, then you'll have to filter the data in the Query Options dialog box on the same criteria you use in Excel. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numeric rounding problems in mail merge with excel data source. | Mailmerge | |||
Word 2002 cannot find its Excel data source for mail merge | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |