|
|
#2
11-03-2021, 07:33 AM
|
||||
|
||||
Update: I just found this post from Macropod which looks like the basis of an answer:
https://answers.microsoft.com/en-us/...f-8642e46fa103 I did some tweaking with the data and made it relational, then followed the post, so I've got the merge itself working now. Unfortunately I'm not able to control the format of the data in the usual way (adding \# "£0.00" to the MERGEFIELD) as it uses sql-type fieldnames, and Word uses (example) £1.9 instead of £1.90 if I try to format as currency in the xlsx data source. Can anyone suggest a way to tackle this issue? 
|
| Tags |
| merge data |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Mail Merge fields merge incorrectly and won't fix.
|
marym | Mail Merge | 3 | 04-09-2016 05:17 AM |
|
Displaying FORMTEXT fields when merge fields are empty or null
|
sfkHooper | Mail Merge | 6 | 01-19-2016 04:24 PM |
|
merge fields disappear in merge doc but prints
|
mdod | Word | 1 | 07-19-2013 06:33 PM |
|
Conditional merge fields in mail merge
|
Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |
|
Need advice on category sorted e-mail merge
|
GeoB | Mail Merge | 3 | 09-08-2011 11:03 PM |
Windows 7 64bit 
Office 2013
Threaded Mode