Mailings Tab

This tab contains everything needed to complete a successful mail merge


Create

microsoft excel docs

Envelopes - Lets you create and print envelopes.
Labels - Lets you create and print labels.


Start Mail Merge

microsoft excel docs

Start Mail Merge - Drop-Down. The drop-down contains the commands: Letters, E-mail Messages, Envelopes, Labels, Directory, Normal Word Document and Step-by-Step Mail Merge Wizard. Creates a from letter which you intend to email or print multiple times sending each copy to a different recipient. Displays the "New Address List" dialog box.
Select Recipients - Drop-Down. The 3 options are from step 3 of the wizard. The drop-down contains the commands: Type New List, Use Existing List and Select from Outlook Contacts. Type New List displays the "New Address List" dialog box. You will have to save this list as a Microsoft Office Address List (.mdb).
Edit Recipient List - Displays the "Mail Merge Recipients" dialog box allowing you to change or filter the list of recipients.


Write & Insert Fields

These commands are only available when you are in a mail merge document.

microsoft excel docs

Highlight Merge Fields - Highlights all the fields in the active document that have been inserted. This makes is easy to see what will be replaced.
Address Block - Displays the "Insert Address Block" dialog box. This allows you to customise how the address will be inserted.
Greeting Line - Displays the "Insert Greeting Line" dialog box. Lets you add a greeting line to your document.
Insert Merge Field - Button with Drop-Down. The button displays the "Insert Merge Field" dialog box. The drop-down allows you to quickly insert a merge field just by clicking on it in the list and contains the commands: Title, First_Name, Last_Name, Company_Name, Address_Line_a, Address_Line_2, City, State, Zip_Code, Country_or_Region, Home_Phone, Work_Phone, Email_Address.
Rules - Drop-Down. Lets you add decision making rules to the mail merge. The drop-down contains the commands: Ask, Fill-in, If-Then-Else, Merge Record, Merge Sequence, Next Record, Next Record If, Set Bookmark, Skip Record If.
Match Fields - Displays the "Match Fields" dialog box allowing you to match the required fields with the recipients list.
Update Labels - Only enabled when creating labels. Updates all the labels in the document to be consistent with the first label.


Preview Results

microsoft excel docs

Preview Results - This is disabled when there are no fields in your document. Toggles the merged fields in your document with actual data from your recipient list.
First Record - View the first record in the recipient list.
Previous Record - View the previous record in the recipient list.
Go to Record - View a specific record in the recipient list.
Next Record - View the next record in the recipient list.
Last Record - View the last record in the recipient list.
Find Recipient - Displays the "Find Entry" dialog box to search for a particular text entry.
Check for Errors - (Alt + Shift + K). Displays the "Checking and Reporting Errors" dialog box. This allows you to simulate the mail merge and to specify how to handle any errors that occur during mail merge. You can even simulate the merge and report errors in a new document.


Finish

microsoft excel docs

Finish & Merge - Drop-Down. The drop-down contains the commands: Edit Individual Documents, Print Documents and Send E-mail Messages.


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext