Quote:
What EXACTLY are you trying to do that no longer works?
|
Earlier my mail merge ran with this query:
Code:
{ DATABASE \d "C:\\Users\\my.user\\Desktop\\FolderName\\sb04_v02HUN.xlsx" \s " SELECT `dtype` as `Jogcím`,
Format(`value_date`) as `Értéknap`,
Format(`principal_amount_mod`,'#,##0') as `Tőke`,
Format(`interest_amount_mod`,'#,##0') as `Kamat`,
Format(`handling_cost_amount_mod`,'#,##0') as `Kezelési ktg`,
Format(`admin_fee_amount_mod`,'#,##0') AS `Admin díj`,
Format(`total_amount_mod`,'#,##0') as `Részösszeg`,
Format(`kesedelmi_kamat`,'#,##0') as `Késedelmi kamat`,
Format(`residual_principal_amount`,'#,##0') as `Fenálló tőketartozás`
from [sb04_2018$]
where `loan_number`= { MERGEFIELD "hitel_azonosito" }
" \l "1" \b "16" \h }
because of some minor changes, the mergefield "hitel_azonosito" was replaced by another field from words' mailsource excel file - so the new field is in the excel file for sure. So after hte change, even re-adding the source excel file to the mailmerge doc, it is not working anymore...
Any hint?