Skip to main content

Looking for an alternative for MS WORD Mail Merge



I am currently working on a problem which requires me to generate a set of MS-Word files which will have almost 90% of their content same only varying in certain fields.


Since these documents are supposed to be classified hence i need my generated documents to be highly precise. Kindly have a look below.



Addressee


Lorem ipsum dolor sit amet, consectetur adipiscing elit, ImportantText sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam.


Quis nostrud exercitation ullamco ImportantDate laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum ImportantDate.



Now i am supposed to use something other that inbuilt MS- Mail Merge. Is there any way to generate such documents where these Addressee, ImportantDate and ImportantText are plenty in number.



Answer



You can use ASK and REF fields.


At the beginning of the document, insert a series of ASK field, one for every bit of information that you need to reuse – for example:



{ ASK Addressee "Enter the name of the addressee" }{ ASK ImportantDate "Enter the important date" }{ ASK ImportantText "Enter the important text" }



The first bit after ASK is the name of the bookmark that will be generated to store the information. The second bit, in quotation marks, will appear as text in the dialog box that prompts for the information.


(Note: For each ASK field that you need, press Ctrl+F9, and then type the field information between the braces ({}) that are generated. Don't simply type a set of braces. Alternatively, on the Insert tab, in the Text group, click Quick Parts > Field, select Ask, and then type the prompt text and a bookmark name in the appropriate fields.)


Then, at each place in the document where you need the stored info to be filled in, insert a REF field – for example:



{ REF Addressee }


Lorem ipsum dolor sit amet, consectetur adipiscing elit, { REF ImportantText } sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam.


Quis nostrud exercitation ullamco { REF ImportantDate } laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum { REF ImportantDate }.



(Note: For each REF field that you need, press Ctrl+F9, and then type the field information between the braces ({}) that are generated. Alternatively, on the Insert tab, in the Text group, click Quick Parts > Field, select Ref, and then select the name of the bookmark in the list.)


Finally, select all, and press F9 to update fields. A series of dialog boxes will open, each prompting for a different piece of information. After you click OK in the last, bookmarks are created to store the info that you entered, and then all the REF fields are filled with the appropriate info.


To generate another doc that has different information, select all and update fields again. Alternatively, after you've inserted the various fields, save the document as a Word template.


Comments

Popular Posts

keyboard - Is there any utility/method to change Windows key bindings to type rare chars to currently empty bindings?

I'm currently typing this post with my windows XP machine and (Spanish) keyboard, and I'd like to add some extra symbols to my text. I could open the "char map" windows utility, look for the desired symbols, and paste them. But I'd like something quickier. For example, when I'm using my OSX Mac at work, I can easily add a ©, ™, ® or similar symbols, just pressing some weird ALT-GR + G / H / J, key combinations. In my (Spanish) keyboard mapping, these combinations are empty, as they don't produce any char at all, which, on the other hand, is perfectly normal and desirable. So, I thought: Why couldn't I add some extra key mappings on top of my currently empty ALT-GR + G/J/H Keys in my Spanish keyboard, and thus, being able to quickly type these special symbols? So that's my question: Is there any utility/method to achieve that effect under windows? (My version is XP). I've even googled this for some time but no luck. I've been a long term Hot...

virtualization - How to select paravirtualization interface in VirtualBox?

Given a windows 8 host system (Intel Core i5) and a Linux Fedora host, I would like to determine the optimal setting for the paravirtual interface. Options are none Default Legacy minimal Hyper-V KVM This page suggest the selection is only based on the guest system: The biggest change in VirtualBox 5.0 is the introduction of paravirtualization support, bringing higher performance and time-keeping accuracy to supported guest operating systems (Hyper-V on Windows and KVM on Linux). Is that correct? Answer The VirtualBox Manual , in the section titled Paravirtualization providers explains very clearly when each should be used (emphasis added): Minimal: Announces the presence of a virtualized environment. Additionally, reports the TSC and APIC frequency to the guest operating system. This provider is mandatory for running any Mac OS X guests. KVM: Presents a Linux KVM hypervisor interface which is recognized by Linux kernels starting with version 2.6.25. VirtualBox's implementati...

Desktop reboots itself on sleep or hibernate

I have been using an ASUS M2NPV-VM motherboard for main home desktop workstation, operating Windows Vista x64. This computer has right from day one not been able to enter hibernate or standby; after Windows performs its final actions and brings the machine down, it would automatically revive itself for a reboot. Updating to the second latest BIOS (1201)has not helped (the latest BIOS revision would induce video refresh problems rendering it unusable). I have been reading related discussions on incidents similar to mine to no avail of a true workable solution. They appear to be more speculative guesses rather than actual knowledge on the inner workings of motherboard hardware. Does anybody have any electronic engineering experience on PC energy-saving standards to provide a more informed opinion how to go about getting this to work? More stories: this motherboard could not even reboot properly the first thing i used it. It was due to refresh rate of the onboard GPU, which had no influe...

security - How is Linux not prone to viruses, malware and those kinds of things?

How is Linux protected against viruses? This question was a Super User Question of the Week . Read the blog entry for more details or contribute to the blog yourself Answer Well, it factually is not... it's just less subject to hackers developing viruses that target Linux systems. Consumer grade computers usually run on Windows and thus, when targeting a wide audience, Windows is the way to go. Don't misunderstand Linux and viruses, there definitely ARE Linux viruses. Some distros have additional protection layers such as SELinux (See here ) in Ubuntu for example. Then there's the default firewall and the fact that alien files don't automatically have permission to be executed. Specific execution permission has to be granted before execution is possible. (See here ) Then there are several other factors that make Linux a hard place to be for viruses usually non-root users on linux systems have no to little executable files at their disposal that would allow for virus...