#1
|
|||
|
|||
Mail merge with Form Fields
I have a client who needs to complete forms for individual clients following pest control inspections. These are currently set up with form fields in Word.
He needs to be able to merge the contact details from an Outlook contact - which I am very comfortable with doing - and then use the form fields in the Word document. Am I best to: 1. Use Content controls in Word? 2. Use Graham Major's tools 3. Use the macros supplied by MS and referenced here within this forum? I am a little confused as to the best way to proceed and appreciate any advice Thank You! Cathy |
#2
|
||||
|
||||
Mailmerge and legacy forms are mutually exclusive. I would suggest using content controls in the document. You can then even put merge fields in the content controls to allow the recipient to change incorrect data.
Insert Content Control Add-In includes an easy way to convert form fields to content controls. If you then wish to mail merge and produce a form that has fields that may be edited, without disturbing any other content, then useE-Mail Merge Add-in and run the following macro from the process to merge to documents or document attachments to e-mail (not PDF or to e-mail body). Code:
Sub LockForm(odoc As Document) Dim oCC As ContentControl For Each oCC In odoc.ContentControls oCC.Range.Editors.Add (wdEditorEveryone) Next oCC odoc.Protect Type:=wdAllowOnlyReading, NoReset:=True, Password:="password" End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
forms fields, merge |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge | djrexy | Mail Merge | 1 | 05-20-2020 04:04 PM |
Mail Merge fields merge incorrectly and won't fix. | marym | Mail Merge | 3 | 04-09-2016 05:17 AM |
Macro to keep formatted form fields after mail merge or replace text with formatted form fields | jer85 | Word VBA | 2 | 04-05-2015 10:00 PM |
Mail Merge a Protected Form Maintaining Form Fills | t/korean85 | Word | 1 | 04-07-2013 05:34 PM |
Conditional merge fields in mail merge | Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |