The Many-to-One add-in is so complex that a lot of it is flying over my head - my own problem. I will probably just have to go back to doing things the long way. Any help would be greatly appreciated, but no worries if it is not something that can be fixed. I could live without these clause references in a short contract, but unfortunately these are important for the longer contracts. Each of the individual clause references are now static text and I cannot ctrl+click on them to bring me to the exact position in the document that they appear. The table of contents seems to contain some hyperlinks but clicking on them does nothing (and the formatting of the table of contents changes). However, after I complete the MailMerge process, these clause references no longer work, whether the output is in DOC/DOCX/PDF format. Even when I export this to PDF, the clause referencing and hyperlinking works. In my base template, all the clause references are properly linked, so ctrl+click on the reference "Annexure C" in the main body of the text will bring me directly to Annexure C of the document. There is also a contents page since longer contracts will need them. While the sample contract contains mostly lorem ipsum text (for confidentiality reasons), I have retained some clause and annexure references in the manner that I usually use them in contracts, these are all highlighted in yellow for easy reference. I have created a sample contract document and linked excel file here Update your browser to use Google Drive, Docs, Sheets, Sites, Slides, and Forms - Google Drive Help (as a side note, I can't believe Microsoft has not yet included this as a built-in function?) But in any case, the file that is generated from this code makes the formatting of my document go haywire - all my numberings and indentations and paragraphing is gone.Ĭan anyone help troubleshoot why this is not working for me? I'm using Office365. While the macro appeared to run, it kept saving over my files (the heading for all files is all the same and I cannot change it for internal policy reasons. However, nothing happens when I click on the "Edit Individual Documents" button.Īlternatively, I also tried the "Send MailMerge Output to Individual Files" option. The macro shows up and there doesn't seem to be any errors in the code, especially since I am merely copying and pasting. I have followed all instructions in Installing Macros (on how to install a macro) and ("Send Mailmerge Output to Individual Files" section). I know this question has been asked to death and I've seen the tips and tricks page. I want to save each MailMerge output file as a separate, individual file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |