Mail merge

Sarki76 · #1 08-30-2019, 01:22 AM

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!

gmayor · #2 09-02-2019, 01:05 AM

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?

Sarki76 · #3 09-02-2019, 01:28 AM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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 - 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