[Video] Mail Merge Guide

Mail Merge is a desktop application designed to send personalized letters for signature to a larger number of recipients than Signatures will typically allow. Once installed, you can create templates and mailing lists to deliver documents like engagement letters in bulk. 

The video below demonstrates how to create Mail Merge templates and complete the Mail Merge process. 

See our Mail Merge Guide for additional information. 

52 STEPS

1. Welcome to the Mail Merge guide! Use the application to create templates and mailing lists to deliver documents like engagement letters in bulk. A Microsoft Word® template and corresponding CSV file are created for this process.

Step 1 image

2. The first step is to open a Microsoft Word® document and click SafeSend Signatures. For help installing the add-in, see our Mail Merge Guide article.

Step 2 image

3. Click E-Sign Action Center to open the add-in.

Step 3 image

4. You can place signature fields on the document. The client will be prompted to perform an action on these fields, except the date field which is auto-filled. Navigate to the page that requires client input.

Step 4 image

5. Click the Signature Placement tab in the SafeSend Signatures add-in.

Step 5 image

6. Select the appropriate Signer from the drop-down.

Step 6 image

7. Place your cursor on the page where the field should be placed.

Step 7 image

8. Double-click to place the field.

Step 8 image

9. The signature block is placed on the form. The client will be prompted to sign here.

Step 9 image

10. Click the signature block to mark the signature as required. This checkbox is de-selected by default.

Step 10 image

11. Continue to place fields for that signer as needed by placing your cursor in the correct location, then double-clicking the signature block option.

Step 11 image

12. Select any additional signers from the drop-down.

Step 12 image

13. Add signature blocks for that signer the same way they were added for Signer 1.

Step 13 image

14. Follow the same steps to place fields like checkboxes.

Step 14 image

15. When a Data Field is added, you can click the block to open a tooltip window and enter a prompt for the client. They will be able to type into this field. Re-size the block on the document to allow for more text.

Step 15 image

16. Select the Required checkbox to require the client to fill the field.

Step 16 image

16b. Click

Step 16b image

17. You can also add merge fields to the document. Data is pulled from the CSV template to auto-fill those fields.

Step 17 image

18. Click the Mail Merge tab.

Step 18 image

19. Place your cursor on the page where the merge field should be placed.

Step 19 image

20. Single-click the merge field to place it.

Step 20 image

21. Click Create Custom Merge Fields to add a new merge field.

Step 21 image

22. Enter a merge field name. Any spaces will be removed. No special characters are allowed.

Step 22 image

23. Click Place Field to apply the new merge field.

Step 23 image

24. Once all Signature and Merge fields are placed, save the Microsoft Word® document.

Step 24 image

25. Click Create CSV Template to generate a CSV file that includes headers for all of your Merge Fields. This CSV file is customized to match the Microsoft Word® template.

Step 25 image

26. Save the CSV template to your PC.

Step 26 image

27. Click OK.

Step 27 image

28. Open the CSV file. The Version number and column headers are generated from the Microsoft Word® file. The Version cell is required and should not be moved or edited.

Step 28 image

29. Do not edit any of the column headers, even if the cell or cells below will be left blank.

Step 29 image

30. Signer1Email and Taxpayer Name are required fields and must be filled. All other fields are optional and can be left blank. If a merge field is left blank, the space occupied by the field in the Microsoft Word® document is removed.

Step 30 image

31. There is no limit on the number of recipients that can be added, but the more recipients there are the longer the merge process will take. Mail Merge can be left open in the background while the files are merged.

Step 31 image

32. Ensure fields that contain numbers are formatted correctly. Microsoft Excel® removes leading zeros by default, so some Client IDs and Zip Codes may be affected. See our Leading Zeros in CSV Template article for more information.

Step 32 image

33. Once all recipient information has been entered, save and close the document. Close the Microsoft Word® document as well.

Step 33 image

34. Open the Mail Merge desktop application.

Step 34 image

35. Click Create Document Template to open Microsoft Word® and build a new template.

Step 35 image

36. Click Open Document Template to upload an existing template. This opens a file browser where you can select the document.

Step 36 image

37. Click CSV FILE to upload your filled CSV file. This opens a file browser where you can select the document.

Step 37 image

38. The uploaded document names are displayed below the upload options.

Step 38 image

39. Click Check Errors to continue.

Step 39 image

40. If no errors are found, the Pre Merge Errors window is blank. If errors are found, they are described in the window. Correct any errors in the Microsoft Word® template and CSV file and upload the corrected documents. Click Merge Files to continue.

Step 40 image

41. The merge progress displays. This may take several minutes to complete depending on the number of documents being merged, but you can allow the program to work in the background.

Step 41 image

42. The Merged Documents List shows what documents and email addresses were recognized. Double click the document name to preview it. Click Configuration to continue.

Step 42 image

43. The Mail Merge Configuration Options display your default Signatures settings. Click Document Type, Expiry Date or Tax Year to edit them.

Step 43 image

44. Select the Sender Signing Order if a Sender Signature block was included in the Microsoft Word® document.

Step 44 image

45. Select an Office Location and Contact Person.

Step 45 image

46. Select a Signing Sequence. Parallel Signing allows all signers to sign at the same time. Custom Signing Sequence forces clients to sign in order. Signer 2 will not receieve an access link until Signer 1 completes signing.

Step 46 image

47. Select a message template from the drop-down, or create a new message by clicking the plus button.

Step 47 image

48. Select Access Code Required to add an additional layer of security. The document recipient is required to enter an access code sent to their email address before viewing or signing.

Step 48 image

49. Click Send for Signature to deliver the documents.

Step 49 image

50. The merge progress displays. This may take several minutes to complete depending on the number of documents being merged, but you can allow the program to work in the background.

Step 50 image

51. Once the items are sent, they appear in your Delivered report in Signatures.

Step 51 image

52. This concludes our tutorial. Thank you for watching!

Step 52 image

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/2411045/Mail-Merge-Guide

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.