![]() The text in an output document can be the same in all output documents, but you can apply formatting to specific documents.īefore you proceed with the Mail Merge Wizard, make sure that your Excel worksheet is well structured for this purpose. The output documents are the result of the mail merge. This database is typically a list of names, addresses, phone numbers, and other categories of personal information. For example, the recipient list is a Microsoft Access database file or an Excel worksheet. The recipient list is a database that contains the data that is to be merged into the output documents. It may contain a letterhead, text, and instructions in merge fields for inserting text (such as recipient names and addresses) that vary from one output document to another. The main document contains the basic text that is the same in all of the output documents. ![]() When you use the Word Mail Merge feature, Word merges a main document with a recipient list to generate a set of output documents: Microsoft word 2010 mail merge how to#This article explains how to use the Mail Merge feature in Microsoft Word to create and to print form letters by using data from a Microsoft Excel worksheet. Microsoft word 2010 mail merge update#Without this, the mergefield hover text won’t update to the correct targets.How to use the Mail Merge feature in Word to create and to print form letters that use the data from an Excel worksheet After merging to a new document, use Ctrl-A, F9 to update all fields. Delete all of the previous display text either side of your last-inserted mergefield (note that this field will likely have updated already).ĩ. Insert a mergefield pointing to whatever data field you want to use for the display text (this could even be the same field as used at step 3 above).ħ. Position the cursor anywhere within the display text.Ħ. In Word 2007 & later, you can make the display text variable also, by following these additional steps:ĥ. Select the field and press F9 to update the display. Replace everything in the field after 'HYPERLINK' with your mergefield.Ĥ. ![]() Select the inserted hyperlink and press Shift-F9 to expose its field code.ģ. Disregarding mergefield issues for the moment, insert a hyperlink into the document in the normal way, choosing whatever 'Click Here' text you want in the 'Text to display' box.Ģ. Here's how you can do get a mailmerge to display your preferred default 'Text to display' text instead:ġ. However, if you don't follow the steps below, the hyperlinks will all show the first record’s address as the 'Text to display' text.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |