Mail Merge: Using One Excel File with Multiple Sheets

macropod · #1 06-22-2021, 03:35 PM

I don't see anything in the 'code' you posted to identify the data source, which is what the string:
\d "{FILENAME \p}/../DB Merge Data.xlsx"

does.

QNRyfzKPYQyC · #2 06-22-2021, 03:39 PM

I've update the original post with attachments I've been playing around with. maybe that helps to solve my issue?

Data source path was actually full path. Without the sql I was able to print the rows from Sheet 2. With the sql I get the error I was talking about

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merge one Excel file into multiple Word Documents	Rushpac	Mail Merge	2	01-27-2017 02:49 PM
Insert slip sheets during a mail merge	mcboats2	Mail Merge	1	12-07-2015 05:01 PM
Mail merge from excel - need to create sheets and create a table	bluenosebex	Mail Merge	5	08-02-2015 05:34 PM
Code for mail merge to reference saved excel file	jtemp57	Word VBA	10	12-16-2013 11:02 PM
How do I merge data from one sheet in a workbook out into multiple sheets	nolesca	Excel	4	06-07-2010 08:13 AM