Mail Merge: Using One Excel File with Multiple Sheets

		Microsoft Office Forums > Microsoft Word > Mail Merge
Mail Merge: Using One Excel File with Multiple Sheets

FAQ

Thread Tools

Display Modes

#19

06-24-2021, 04:13 PM

macropod

Windows 10 Mail Merge: Using One Excel File with Multiple Sheets

Office 2016

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

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}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:53 AM.