Mail Merge: Using One Excel File with Multiple Sheets

macropod · #1 06-24-2021, 04:13 PM

Since your {MERGEFIELD producentid} outputs a number, you need to enclose it in tick marks:
{DATABASE \d "{FILENAME \p}/../factuur.xlsx" \s "SELECT [ean], [rate], [count], [market], [deposit], [pb], [vat], [amount] FROM [overview$] WHERE [producentid] = '{MERGEFIELD producentid}' ORDER BY [amount]" \l "15" \b "49" \h}

QNRyfzKPYQyC · #2 06-25-2021, 12:39 AM

Quote:

Originally Posted by macropod

Since your {MERGEFIELD producentid} outputs a number, you need to enclose it in tick marks

Yes! You're a hero, thx

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