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 to get a mailmerge to display your preferred default 'Text to display' text instead:ġ. Related Reading: Mail Merge in Google Sheets. Mailmerge Hyperlink ‘Click Here’ Insertionīy default, if you insert a mailmerge field into a hyperlink field, the hyperlinks will all show the first record’s address as the 'Text to display' text. Here, you can format the numbers as currency and percentage and increase and decrease the decimal places. However, you can still achieve the same outcome - and with greater control - via the 'Edit Recipient List' tools. Specifically, you're looking for Switches. The potential disadvantage of intercepting the 'Edit Individual Documents' process this way is that you no longer get to choose which records to merge at that stage. In the Word Helpfile look up Format Merge Data->Change other formatting by using field codes. Fields(i).UnlinkĮnd SubIf you're using Word 2007 or later, your mailmerge main document will need to be saved in the. 'īy adding the following macro to your mailmerge main document, clicking on the 'Edit Individual Documents' button will intercept the merge, finishing it and unlinking the pictures (and any other residual fields except for hyperlinks). Convert Text Representations of Fields to Working Fields.įor PC macro installation & usage instructions, see: Installing Macros.įor Mac macro installation & usage instructions, see: Word:mac - Install a Macro.Split Merged Output to Separate Documents and.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |