How do I… Integrate mail merge in Microsoft Word with Excel
by Scott Lowe MCSE | September 26, 2010, 10:28am PDT | Image 6 of 18
Select the sheet on which your information resides
Most people are not familiar with "Named Ranges" in Excel (I'll cover them in a future article), so the resulting window might be a little confusing at first since it looks like gibberish. Notice that three of the four choices are the names of the individual sheets (Sheet1, Sheet2 and Sheet3). In my Excel file, the inventory information is on "Sheet1", so I will choose the corresponding option from the Select Table window. Note also the "First row of data contains column headers" option at the bottom of this window. As I mentioned before, it's really a good idea if you include headers in your spreadsheet. However, if you don't want to do so, make sure you uncheck this box. If you don't, Word will assume that the first row of your data contains headings.
Select the sheet on which your information resides - Image 6 of 18
Related Galleries
No messages found
No messages found
0
Votes
Question on mail merging charts
You say "store the charts with a name that includes an ID field". Where do you "name" the chart? I just opened Excel 2010 and in the Chart Tools > Layout ribbon there is a box for Chart Name in the Properties group. Is this what you mean? Also, in your field string, if all data (Excel and Word) is stored locally, skip the drivename and directory level references? Finally, if your empIDChartname is 12345Pay, where does that appear in your code statement? Drop it in where you have }Pay?
Sorry for all the questions; trying to sort this all out!
Sorry for all the questions; trying to sort this all out!
Log in to display your contacts' posts.
Once logged in, adding contacts is simple. Just mouse over any member's photo or click any member's name then click the "Follow" button. You can easily manage your contacts within your account contacts page.
