Solved

How to strip word docx from 'template-fields' after mailmerge?

Posted on 2016-08-25
3
65 Views
Last Modified: 2016-08-26
We have a PHP mailmerge app that unzips docx, substitutes mailmerge fields and zips them back, it all works fine and looks ok when opening. But if i try to print this 'new' document, all fields that were filled after opening, now have error messages in them. To resolve, we have to do ctl-a (select all) and shift-f9 in word and now all data is included and we can print the document.

I am looking for an alternative solution to the ctl-a shift-f9 in word, we are talking about hundreds of documents and although we have a macro solution we are looking at, we'd rather fix this at the php level when mailmerge is still going on.
How could we do this, fe. using the dom-structure of php, maybe disconnecting the fields from the value or something like it.
285_421_2_1_20160816_example.docx
0
Comment
Question by:zebrain777
3 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 41770463
The MailMerge process creates one or more documents from the  Main document but puts the values from the data record where the merge field is on the main document.

The main document does not get modified in the process. There are no merge fields in the output document(s).

Your document does not contain merge fields. The fields are REF fields, which are intended to show the contents of  bookmarks elsewhere on the document. There do not seem to be any bookmarks in your document.

I don't speak PHP, but there is a Fields.Unlink method that can be used programatically.
0
 
LVL 14

Expert Comment

by:DrTribos
ID: 41770926
Um.... why not just use the PHP to operate on a temporary copy of the document instead of unzipping the original, OR create a backup of the doc and use the PHP TO restore...?
0
 

Author Comment

by:zebrain777
ID: 41771705
Hmm not sure what happened with my previous comment, so i will try again:)

@GrahamSkan, ty i am now looking at SimpleXml for php wich seems capable of doing that. My problem is that xml is not my usual cup of tea i guess but the unlink comment may get me where i need to be, so i will accept your solution.

@DrTribos, yes there is a copy made of the original template, that one is processed, and is the one attached to the questiong, just manually manipulated for privacy reasons.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now