

often Avery A4/A5įrom the Product number list choose label type and click Ok When your letter is ready for distribution click Next: Preview your letters.Ĭheck how your data looks using the tools in the right hand panel.Ĭlick Next: Complete the merge - where you can print or further personalise your letters.Ĭlick the dot next to Labels and click Next: Starting documentįrom the ‘Label vendors’ drop down choose the brand of your label. Choose the field then click ‘Insert’ to add the merge field to your letter. Where merge data is required in your document, position the cursor at that point then click More items… from the right hand panel. When finished, click ‘Ok’.Ĭlick Next: Write your letter and create/edit your letter. The fields and data will open giving you the chance to unselect any fields or data you don’t require. Click ‘Browse’ and navigate to the file you saved from edge.Ĭlick on the file name, then click ‘Open’. Leave the dot in Letters and click Next: Starting documentĬhoose ‘Use the current document’ then click Next: Select recipients.Ĭhoose your data source to be merged into your letter. and a panel will appear on the right of the screen with Steps 1 of 6 listed at the bottom In Microsoft Word open a new document or open the file you want to create a mail merge documentĬhoose the Mailings tab, and select ‘Start Mail Merge’Ĭhoose Step by Step Mail Merge Wizard. Click this and a data.xlsx file will be saved into the default Downloads folder on your computerįor more help on this including removing duplicates Merging data to a letter in MSWord People > Caregivers > Export Contact Details Select the classes you require then click ‘Export’Īfter a short time a ‘Download the Contact Export File’ link will appear on the page. Select the students and information you wish to exportĪ StudentQuery.csv file will be saved into the default Downloads folder on your computer

People > Students > Student Lists > Filterable Lists link Here's advice for merging data into MS Word 20 from edge.īoth Student and Caregiver data can be exported from edge. Microsoft Word merge features can be used with your edge data to produce individually customised letters and labels.

Mail Merge in Microsoft Word for letters and labels
