Mail Merge w/ Multi-paged Excel Source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dominique Feteau - 24 Feb 2004 21:11 GMT

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

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 25 Feb 2004 05:38 GMT

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.

Signature

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

>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

Reply to this Message