Choosing which Excel Worksheet

L

Lisa M.

I am creating a mail merge into word using a multi-worksheet excel file. Word defaults into using the first worksheet out of the file as the data source. How do I specify which worksheet within the file to use

Ex. If I have an Excel file containing worksheets for January through December, how do I tell Word to merge using the data on the July worksheet?
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?TGlzYSBNLg==?=,
I am creating a mail merge into word using a multi-worksheet excel file. Word defaults into using the first worksheet out of the file as the data source. How do I specify which worksheet within the file to use?
Click to expand...
Seems to me I answered this already during the past week...

Which version of Word is involved, here?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Mail Merge Directory Conditional Page Break 0
Merging from an Excel file with graphics 1
Mail Merging into PowerPoint 0
VBA to do a mailmerge from a Specific Excel worksheet 0
Page numbering with Merged Document and IF statements 1
Pasting a cell into bookmarked table from excel vba 1
VBA code in Excel opens Word template and fills bookmarks, but can't get correct formatting 5

Top