View Single Post
Old 10-13-2021, 01:31 AM
Yiii Yiii is offline Mac OS X Office 2019
Join Date: Oct 2021
Posts: 1
Yiii is on a distinguished road
Default Please help!

Originally Posted by macropod View Post
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}
I have attached 2 document to this reply. I'm very new to this mail merge functions. This is an interview question posted by the employer.

Could you help on this? Please. The deadline is 13 Oct 2021 10:00pm.
Attached Files
File Type: xlsx test case contact details.xlsx (13.9 KB, 0 views)
File Type: docx test case email content.docx (14.0 KB, 1 views)