You have the option to Print or Edit individual labels from there. Then hit Next: Preview you labels at the bottom to view the labels: 14.
Then hit the Update all labels button to update the entire page: 13. You will also have to add some spaces and other formatting to the document.Ĭhanging the formatting will change the document from this: To this:ġ2. If you choose the Database Fields option you can select the lines you want to add. Add a space between each option you chose, and put them in proper rows.ġ1. (Normally select First Name, Last Name, Address 1, City, State, Postal Code) Then you will have to do additional formatting to your document. In the Insert Merge Filed window select and insert the options you wish to add to your mail merge document, and in the order you want them to appear.
If you click on the Address Fields button you will need to insert each option one by one. On the Mailings tab, click Start Mail Merge, and then click Step by Step Mail Merge Wizard.
Click on the blue More items... It will bring up this window.ġ0. So, mail merge just makes it a lot easier for you to send mail to multiple recipients without much manual effort. Then keep following the wizard prompt by clicking Next: Arrange you labels at the bottom.ĩ. User Replied on JOpen Mail -> Preferences -> General -> set default email reader to Microsoft Outlook. Once you click OK, your word doc will look like this, or similar depending on formatting: 8.
Then it will bring up a verification page like this:ħ. When choosing use an existing list, and browsing, you can select a document (such as excel) with the addresses in it. If you choose to type a new list you will need to select the blue create button and a window will pop up to create the contacts for the document.Ħ.That will bring up a window for you to select the correct folder. If you choose to s elect from Outlook contacts you will have to select the blue c hoose contacts folder button.If you choose to using an existing list, then you will need to select the blue browse button.Then choose one of the options at the top – using an existing list, select from Outlook contacts or type a new list. When sending to a group, the email cannot be personalized for each recipient and youll also not be able to track which member of the Gmail group opened or. Hit Next: Select recipients at the bottom. Select whether to use the current document (can be an existing document, Excel), change document layout or start from existing document.ĥ. A new window will come up that looks like this:Ĥ. Select label options in blue to choose the correct formatting. Follow the Mail Merge Wizard by choosing the type of document (labels, letters, envelopes etc.) and hit Next at the bottom.ģ. A Mail Merge window should show up on the right.Ģ. Click on Start Mail Merge Button and select the Step by Step Mail Merge Wizard from the drop down menu. If it does not, then check each merge field (hover the mouse over the field to see summary info double-click on the field for details) to be sure that it references the proper data source name and field name.Mail Merging is very useful when sending the same source to multiple addresses.ġ. The data from that row should appear in the document. Select a data row and click the "Data to Fields" button in the toolbar above the data grid. NOTE: Attachments are not an option in an email merge. In the data sources list (left sub-panel), navigate to the data source and data table for the document the proper data should appear in the grid (right sub-panel). Your email merges will be recorded in your sent items folder. If it does not, then the data source needs to be registered. The merge document's data source should appear in the list of databases at the left sub-panel.
Press F4 to view the data sources panel (View > Data Sources). My go to for debugging merge documents is to attack it manually.
At least that's what I get, either before any data are merged, or if OO Writer can't fill the field for some reason. It's hard to troubleshoot this without having the document and data files, but I believe the "" display is an indication that no data is available for that field item. One thing to check: View > Field names: OFF (this displays the field names instead of the data from the field) they all just show the field name on each one. Mac users - If you need to open Microsoft Outlook emails and attachments that are saved in.