Can a Data Source be one sheet in a multi-sheet Workbook

nfotx · #1 06-30-2015, 02:29 PM

If I have a Excel Workbook can I add a new sheet to the Workbook make into a Data Source for mail merging?

macropod · #2 07-01-2015, 12:55 AM

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.

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