![]() |
|
#1
|
||||
|
||||
![]()
Actually I have thought of a way to address this problem.
If you install my Many To One mail merge add-in and use it in One to One mode to merge the document with its data, the cross references are preserved. This is because the process does not use mail merge, except as a means of inserting placeholders for the data. The merge document is used as a template and filled each time with the data for the records being merged. Merge Many To One
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#2
|
|||
|
|||
![]()
I see - I will give this a try next week and update you on the results. Thanks!
|
#3
|
|||
|
|||
![]()
Reporting back!
The Many-to-One add-in is so complex that a lot of it is flying over my head - my own problem. I will continue to try and figure it out and in the meantime I will use the simpler Merge and Split add-in instead for shorter documents where the clause reference hyperlinks are not crucial. If you don't mind, I have been exploring your other works (you are a true hero and I appreciate all the work you've done for the community), and have a couple of quick queries on some of them - but these are not urgent at all and they can certainly wait. 1. Multiple Document Merge: I test ran it using your Example Data set and my own data set and found that when I ran the process, the system would constantly prompt me to run the SQL command "SELECT * FROM 'Sheet1$' and then I have to navigate to the folder and select the excel sheet again for each separate document. This means if I have 3 documents for output and 5 datasets, I get 15 prompts and have to navigate to find the excel sheet 15 times. Am I perhaps doing something wrong? 2. Boilerplate: Is there a simple way to remove only one boilerplate from the long list of boilerplates I have created? I tried deleting the reference document in the folder but it continued to show up in the add-in list. I couldn't amend the table in the template document to remove just that one line either. So far I found that I have to (i) delete the reference document in the folder, (ii) reset the whole add-in and (iii) relink the folder so that everything is repopulated without the deleted boilerplate. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
alexandersmit | Mail Merge | 2 | 11-02-2020 02:48 PM |
![]() |
MichalJankowski | Mail Merge | 1 | 02-11-2017 04:45 AM |
Printing a Mail Merge output file | Ar-Pharazon | Mail Merge | 7 | 09-13-2014 07:11 AM |
mail merge – output to .pdf | eNGiNe | Mail Merge | 3 | 09-29-2013 11:45 PM |
![]() |
Calastein | Mail Merge | 3 | 05-04-2011 01:50 AM |