Hi, going insane. I've managed to get a copy of the examples above working as it should. However with my own data it doesn't fly. Would you mind taking a look and see what I'm doing wrong?
{
MERGEFIELD producentid }
{ MERGEFIELD producentnaam }
{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}
factuur.docx
factuur.xlsx