Word: Mail Merge GCFLearnFree.org English English (auto-generated)

Word: Mail MergeYouTube↗ IA↗(long shot)
Education 904.7K views 5K likes 221 dislikes 08 Feb 2016

LearnFree 1.2M subscribers N/A YouTube↗

Click to Play Video

Goodwill Community Foundation creating opportunities for a better life mail

Mail Merge is a great time saver if you need to create multiple documents

merge is a great time-saver if you need to create multiple documents that are

that are mostly the same but unique in some way, such as names tags for an event or

mostly the same but unique in some way like name tags for an event or envelopes

envelopes printed with each person's name and address. The document I have here is a letter offering customers a discount on their next order.

printed with each person's name and address the document I have here is a letter offering customers a discount on

I want to personalize it by addressing each copy of the letter to the customer

their next order I want to personalize it by addressing each copy of the letter to the customer

using some information I have stored in a spreadsheet. To begin go to the Mailings tab, then click Mail Merge and select

using some information I have stored in a spreadsheet to begin go to the mailings tab then start mail merge and

Step-by-Step Mail Merge Wizard.

select step by step mail merge wizard

This will walk you through the process one step at a time using this pane on the right.

this will walk you through the process one step at a time using this pain on the right the type of document I'm

The type of document I'm working with is a letter so I'm going to go ahead and click Next.

working with is a letter so I'm going to go ahead and click Next

I also plan to stick with my current document instead of using something else, like a template.

and I also plan to stick with my current document instead of using something else like a template

Now I need an address list so Word can create a copy of each letter for each customer. To start from scratch, you can Type a new list

now I need an address list so we can create a copy of each letter for each customer to start from scratch you can type a new list then click create to

then click Create to enter your recipients individually.

enter your recipients individually

Alternatively, if you do a file

alternatively if you do have an exist

with the information you need, like an Excel workbook in my case, select Use an existing list,

document with the information you need like an Excel workbook in my case choose use an existing list then browse to find

then Browse to find it.

it

Now click Open and select the worksheet that contains the list.

now click open and select the worksheet

I know mine is in sheet 1.

that contains the list I know mine is in sheet 1

You can uncheck any recipients that you don't want to include.

in this example you can uncheck any recipients that you don't want to

I want to include everybody though so I'm going to go ahead and click OK,

include I want to include everybody though so I'm going to go ahead and click OK

and now it shows that workbook as my recipient list.

and now it shows that workbook as my recipient list so now it's time to write

So now it's time to write my letter.

my letter you can add something unique

You can add something unique for each recipient including their address,

for each recipient including their

a personal greeting, and more.

address a personal greeting and more I'd

I'd like to add an address block first. Just place your cursor where you want to go,

like to add an address block first just place your cursor where you want it to go

then click the item.

then click the item

Here's a preview of what it's going to look like and a few alternative formats

here's a preview of what it's going to look like and a few alternative formats

to choose from for the recipient's name.

to choose from for the recipients name

Click OK and a placeholder will appear in your document. This is where the address will go later on. The other thing I'd like to add is a greeting.

like okay will appear in your document this is where the address will go later on like to add as a greeting

Again you have the ability to change some of the formatting if you'd like.

again you have a preview here and the ability to change some of the formatting if you'd like

Let's move on to the next step:

let's move on to the next step

previewing the finished product.

previewing the finished product

I just want make sure that

I just want to make sure the information

the information from my list appears the way it should.

from my list appears the way it should

You can take a look at each recipient's copy by clicking the arrows here.

you can take a look at each recipients copy by clicking the arrows here

Everything looks great so let's complete the merge.

everything looks great so let's complete the merge

if you click the Print command, Mail Merge will ask which pages you want

if you click the print command mail merge will ask which pages you want to

to print before sending you to the final step.

print before sending you to the final

I went to print every document my recipient list so I'm just going to keep all.

step I want to print every document in my recipient list so I'm just going to keep all

Now all you have to do is adjust the settings if you need to, then click OK

now all you have to do is adjust the settings if you need to then click okay

Knowing how to use mail merge is a must for creating multiple letters, labels, envelopes, and more.

knowing how to use male marriage is a must for creating multiple letters labels envelopes and more the

The possibilities, along with the time and energy you'll save, are practically endless.

possibilities along with the time and energy you'll save are practically endless

Similar videos:

Word 2013: Mail Merge
LearnFree
162.2K views 379 likes 37 dislikes 13 Dec 201387% match

Word 2010: Mail Merge
LearnFree
281.6K views 1.2K likes 72 dislikes 14 Feb 201184% match

Word: Headers and Footers
LearnFree
722.4K views 1.8K likes 299 dislikes 08 Feb 201665% match

How to Create Mail Merge Labels in Word
Joe Cullen - Shotcut Tutorials
82 views 5 likes 0 dislikes 13 Jan 202060% match

How to Mail Merge with individual attachments in Word
MAPILab
1.1K views 4 likes 0 dislikes 11 Jun 202060% match

Word: Page Numbers
LearnFree
992K views 2.4K likes 340 dislikes 08 Feb 201659% match

Word: Tables
LearnFree
186.2K views 404 likes 39 dislikes 08 Feb 201657% match

Word: Indents and Tabs
LearnFree
703.8K views 2.5K likes 165 dislikes 08 Feb 201654% match

Word: Track Changes and Comments
LearnFree
708.5K views 3.9K likes 90 dislikes 08 Feb 201651% match

Word: Using Find and Replace
LearnFree
410.6K views 845 likes 88 dislikes 08 Feb 201649% match

Word: Line and Paragraph Spacing
LearnFree
719.1K views 1.7K likes 192 dislikes 08 Feb 201648% match

Word: Getting Started
LearnFree
1M views 1.8K likes 140 dislikes 08 Feb 201643% match

Word: Page Layout
LearnFree
411.6K views 596 likes 82 dislikes 08 Feb 201641% match

Word: Creating and Opening Documents
LearnFree
427.1K views 727 likes 69 dislikes 08 Feb 201641% match

Word 2016: Pictures and Text Wrapping
LearnFree
438.7K views 1.1K likes 132 dislikes 08 Feb 201640% match

Word 2016: Check Spelling and Grammar
LearnFree
389.8K views 1.2K likes 108 dislikes 08 Feb 201638% match

Word: Text Basics
LearnFree
387K views 482 likes 64 dislikes 08 Feb 201634% match

Access: Designing a Simple Query
LearnFree
770.5K views 4.5K likes 151 dislikes 08 Apr 201632% match

Excel: Getting Started
LearnFree
1M views 1.2K likes 98 dislikes 08 Feb 201631% match

Excel: Cell Basics
LearnFree
533K views 599 likes 60 dislikes 08 Feb 201629% match

Excel: Modifying Columns, Rows, and Cells
LearnFree
739K views 1.9K likes 135 dislikes 08 Feb 201629% match

Access: Creating Forms
LearnFree
587.8K views 2.2K likes 119 dislikes 08 Apr 201629% match

Excel: Creating and Opening Workbooks
LearnFree
426.5K views 396 likes 41 dislikes 08 Feb 201629% match

PowerPoint: Inserting Audio
LearnFree
1.2M views 6.5K likes 304 dislikes 17 Mar 201629% match

Excel: Intro to Formulas
LearnFree
569.9K views 832 likes 50 dislikes 08 Feb 201629% match

Excel: Sorting Data
LearnFree
582K views 1.5K likes 81 dislikes 08 Feb 201628% match

PowerPoint: Inserting Videos
LearnFree
1.2M views 5.6K likes 244 dislikes 17 Mar 201628% match

Excel: Page Layout and Printing
LearnFree
825.9K views 2.1K likes 166 dislikes 08 Feb 201626% match

Video Editing Tip: How to Blur Face/Video on CapCut
LC Editing
42K views 1.1K likes 25 dislikes 13 Oct 202026% match

How to Use Keyframes in CapCut in 2020
LC Editing
47.3K views 1.3K likes 32 dislikes 18 Aug 202025% match

Settings Privacy About Contact Donate