Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-30-2019, 01:22 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
Unhappy Mail merge - data sources

Dears,
Recently I have created a mail merge document using sources from here, worked like charm -> I've created over 2k+ docs in an hour.
But, then something happened, office or op-system update and now the where clause stops the whole procedure -> I've become very confused about this case.


Q: is there any way to replace my excel files as datasources to eg text file, either csv or rich text or any other offfice supported?


Q: what can cause this issue as if I use a simple select field1, field2, etc or I simply put select * to the statement, works like charm....
Once I start the where clause it displays an error message that missing parameter or can not connect to datasource or invalid function... Very-very-confused


Any hints or idea?
Thanks in advance!
Reply With Quote
  #2  
Old 09-02-2019, 01:05 AM
gmayor's Avatar
gmayor gmayor is offline Mail merge - data sources Windows 10 Mail merge - data sources Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You can use any compatible data source but it is unlikely to make any difference.

What EXACTLY are you trying to do that no longer works?
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #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
Reply

Thread Tools
Display Modes


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 06:56 AM.


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