#1
|
|||
|
|||
Can a Data Source be one sheet in a multi-sheet Workbook
If I have a Excel Workbook can I add a new sheet to the Workbook make into a Data Source for mail merging? |
#2
|
||||
|
||||
Yes but the mailmerge can only access a single sheet and, on Macs, you can't specify only part of the sheet for that - the mailmerge will use the whole worksheet.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Move data from one sheet to the next available row or cell of another sheet | bwwalker08 | Excel | 0 | 04-10-2015 11:51 AM |
Populate sheet 3 with data from sheet 1 and sheet 2 | speck | Excel Programming | 0 | 01-14-2015 07:54 AM |
Help Coloring a cell in Sheet one if data is missing from another sheet | Aeducan | Excel | 1 | 06-22-2014 04:49 PM |
VBA: Include Dynamic Sheet Name In Pivot Table Source Data | ibrahimaa | Excel Programming | 2 | 04-28-2012 12:27 AM |
How do I merge data from one sheet in a workbook out into multiple sheets | nolesca | Excel | 4 | 06-07-2010 08:13 AM |