Mail Merge w/ Multi-paged Excel Source

[Dominique Feteau]

I have an excel document with customer information and a word file that I
want to use a mail merge. The excel sheet has different sheets based on
month. How can I set up the word document to use the information on a
certain sheet? (e.g.: January, but not February)

Dominique

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Dominique,

Under Tools>Options>General, check the "Confirm conversion at Open" box.
Then when you select the datasource for the mailmerge, it will give a number
of options for the method of making the connection in a "Confirm Data
Source" dialog. Select the OLE DB Database Files option and then a dialog
will appear that contains a list of the sheets in the Excel file.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP