Tip - Create Letters or Labels using Mail Merge Wizard [PDF]

www.kindergarten.vic.gov.au [email protected]. State Library of Victoria, 328 Swanston St, Melbourne, VIC 300

16 downloads 24 Views 376KB Size

Recommend Stories


How To Mail Merge PDF Documents
At the end of your life, you will never regret not having passed one more test, not winning one more

Print Merge Tip sheet
Be grateful for whoever comes, because each has been sent as a guide from beyond. Rumi

Cisco Voice Mail Port Wizard
I tried to make sense of the Four Books, until love arrived, and it all became a single syllable. Yunus

Join or Merge?
And you? When will you begin that long journey into yourself? Rumi

membuat mail merge dengan microsoft office 20071
At the end of your life, you will never regret not having passed one more test, not winning one more

Using the Grading Wizard
Never let your sense of morals prevent you from doing what is right. Isaac Asimov

s labels using
The beauty of a living thing is not the atoms that go into it, but the way those atoms are put together.

Microsoft Office for Mac 2011 Tutorial: Use Mail Merge to create a form letter.docx
Never let your sense of morals prevent you from doing what is right. Isaac Asimov

[PDF] The Water Wizard
If you are irritated by every rub, how will your mirror be polished? Rumi

Sample Bankruptcy List Marketing Mail Letters
Silence is the language of God, all else is poor translation. Rumi

Idea Transcript


Tip - Create Letters or Labels using Mail Merge Wizard (Instructions based on Microsoft Word 2007, but similar in Microsoft Word 2010). Use the Mail Merge step-by-step Wizard when you want to create a set of labels or documents such as a standard letter that is sent to multiple recipients. You will need: 1) A letter or blank document. 2) Your recipient information (name, address) stored in a separate file, such as an Excel Spread sheet. 1. Open your Word document, you can begin with a blank document or you can write a letter 2. Go to the Mailings tab 3. Click on Start Mail Merge, then Step by Step Mail Merge Wizard Step 1: Select document type 1. Select the document type (Letters, Labels) 2. Click Next: Starting document Step 2: Starting document 1. If you’re creating Letters select Use the current document 2. If you’re creating Labels, click Label Options. Select the Label Vendor and Product Number (this information is found on the packet of labels that you will use (Avery A4/A5, L7159). Click OK.

3.

Click Next: Select Recipients

Phone: (03) 8664 7001 Free Call: 1800 629 835 Fax: (03) 9639 2175

www.kindergarten.vic.gov.au [email protected] State Library of Victoria, 328 Swanston St, Melbourne, VIC 3000 Australia The Kindergarten IT Program is supported by the Victorian Government.

Step 3: Select the Recipient List In this step you will locate your file of recipient information (name, address). This can be stored in a Word or Excel file, where each row contains individual recipient information.

1. Select Use an existing list 2. Click Browse and locate the existing file on your computer 3. Select the file, and click Open, if it is an Excel file, select the sheet (worksheet), click OK 4. Review the data source and use the check boxes to add or remove recipient details from the merge Step 4: Write your letter/ arrange your labels In this step you will choose which fields to merge into the document and where they are positioned. 1. To add the recipient information, place the curser at the desired point then click on ‘More items’ select each merge field and click Insert. Click Close.

2. Rearrange the position of each field until you are happy with the layout 3. If your creating Labels, click ‘Update all Labels’ 4. If your creating Letters write the letter but don’t touch the merge fields which appear surrounded by chevrons (>). Step 5: Preview your letters/ labels 1. Click on Next Record or Previous Record to preview each individual letter. If it doesn’t look right, return to Step 4 to edit the fields to be merged and remember to update labels with the fields to be merged. Step 6: Complete the merge 1. Here you can Edit individual letters and click OK to save the letters OR 2. Click Print then OK to print the letters/ labels.

Smile Life

When life gives you a hundred reasons to cry, show life that you have a thousand reasons to smile

Get in touch

© Copyright 2015 - 2024 PDFFOX.COM - All rights reserved.