Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 09-02-2019, 01:28 AM
Sarki76 Sarki76 is offline Mail merge - data sources Windows 10 Mail merge - data sources Office 2019
Novice
Mail merge - data sources
 
Join Date: Jun 2019
Posts: 7
Sarki76 is on a distinguished road
Default

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?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Choosing Mail Merge templates and excel Data Sources using drop downs dushan997 Mail Merge 3 08-04-2017 07:54 PM
Copy and Paste mailmerge data sources in bulk iv_tavares Word VBA 3 05-18-2017 06:28 PM
Mail merge - data sources Mail Merge - Many to One w/MS Access data mklepper Word 1 03-07-2015 08:30 AM
Data gathering from varied sources for different outcome letters cs225 Word 2 10-19-2014 06:23 AM
Is data merge and mail merge the same thing? ikearns Mail Merge 1 09-12-2014 03:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft