Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Word | Write a personalized letter in Word using Excel data
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

Write a personalized letter in Word using Excel data

Mail merge is one of the most useful features of Microsoft Word when wanting to send personalized letters, documents or e-mails to people you have stored in an Excel sheet. Let me show you how to use it.

 
  Author: mat | Version: 2010 | 1st May 2013 |  
 
 
1.
 

I have an Excel document with people's titles, names and last names.

You can also have other personal info like addresses or emails stored in the sheet. Sky is basically the limit.

 
 
2.
 

Open Microsoft Word and click Mailings in the menu.

 
 
3.
 

Click Start Mail Merge and choose Step by Step Mail Merge Wizard...

 
 
4.
 

As I want to write a personalized letter containing individual names, I chose Letters.

 
 
5.
 

Click Next: Starting document.

 
 
6.
 

I want to use the current empty document I'm currently in.

If you already have a document you want to send out, then choose the Start from existing document option.

 
 
7.
 

Click Next: Select recipients.

 
 
8.
 

I have and existing excel list of people I want to send a letter to (step 1) that's why I chose the Use an existing list option and then click Browse...

 
 
9.
 

Find the Excel document with people you want to send the letter to and open it.

My excel document is called Recipients.xlsx.

 
 
10.
 

All my contacts are in the Sheet1 of the Excel document.

If the first row of the sheet with the contacts (like in my case) contain the column header (Title, Name, Last name,....) then choose the First row of data contains column headers option.

Click OK.

 
 
11.
 

Here are now all my recipients. As I want title to be before the name, I can simply click and drag it...

 
 
12.
 

... in front of the Last name.

 
 
13.
 

You can also Sort, Filter or even Find the duplicate entries of you want.

When done click OK.

 
 
14.
 

If you don't have the letter written yet, like myself then click Next: Write your letter.

 
 
15.
 

To add the greeting (the personalized part) click Greeting line...

If you have also address stored in your Excel document, then you can also click Address block to add the addresses to your letter.

 
 
16.
 

You can now choose how you want to great your recipients. You can choose from the available options like Dear or type your own.

You can also choose to address the recipient with only the last name or name and last name combined.

Click OK when done.

 
 
17.
 

«GreetingLine» is where the greeting will appear.

Same goes for the address block if you chose it as well. You can cut and paste it anywhere you want, just be sure it remains exactly as it was.

If you didn't write the letter yet, then write it now.



 
 
18.
 

When done writing a letter, click Next: Preview your letters.

 
 
19.
 

You can now click through all the recipients you added. Notice how the letter remains the same and only the recipients change.

If you want to exclude a certain recipient then simply click Exclude this recipient.

 
 
20.
 

When done reviewing your personalized letters, click Next: Complete the merge.

 
 
21.
 

When merge is done, you can click the Finish & Merge then choose what you want to do.

If you want to print out the letters with different recipients choose the Print Documents... option, if you want to send E-mails choose Send E-mail Messages...

 
 
 
   
  Please login to post a comment
  Click to open user profile  
davidsithole2, 4th Dec 2021, 11:47 AM
Create, publish and monetize interactive content on your website. Quizterra is a functional quiz making software with great designs, wide functionality and free embed

 
 
  Click to open user profile  
davidsithole2, 4th Dec 2021, 11:47 AM
Create, publish and monetize interactive content on your website. Quizterra is a functional quiz making software with great designs, wide functionality and free embed

 
 
  Click to open user profile  
AlexChudovo, 30th Dec 2021, 9:56 AM
Hello, my name is Alex! I am a Front End software developer and work in IT company Chudovo. I can recommend this company as a reliable partner and provider IT services. Feel free to visit our website https://chudovo.com/.
 
 
  Click to open user profile  
Christian21, 14th Jan 2022, 1:26 PM
Chudovo - boutique software development company with development office in Kyiv, and representatives ones in Cologne, New York, Tallinn and London. It has been working on the market since 2006.Company has domain expertise in in healthcare, logistics, education, media and entertainment, finance and telecommunication industries. Chudovo has successfully finished projects in corresponding areas, having spent hundreds of man-years on implementation of thematized software.We provide custom software development services and solutions to businesses of any size. We can help you with any stage of software development process, individual project, IT security, recruiting and branch organization consulting.

 
 
  Click to open user profile  
idasanka, 6th Feb 2022, 2:46 PM
Very helpful and good value as well. Will definitely use them again https://carwrapsstocktonca.com
 
 
  Click to open user profile  
betbhai9, 19th Jan 2023, 10:51 PM
Agr apko online betting karke paise kamana hai to apko betbhai 9 platform par ana pdega ur wha akar apko kuch paise spent karne padege. Fir apko bidding karning padegi wha par, dekna padega ki kaha apko fayda ho rha hai ur kaha ni ye apko khud dhyan rkna pdega. But betbhai 9 me apke kafi chance hote hai ki paise jeetne ke, to aj he ap betbhai9 login id le ur betting suru kare. Best of luck. For more info. visit at: https://betbhai9.app/
 
 
  Click to open user profile  
propharmacysh, 29th Jan 2023, 7:33 PM
Buy Kamagra Chewable Pills Visit our website at: https://propharmacyshop.com/product/buy-....

 
 
  Click to open user profile  
madhurday, 19th Feb 2023, 2:43 PM
Madhur Night, Visit our website: https://madhurday.in/
 
 
  Click to open user profile  
helenabravo, 17th Apr 2023, 11:26 PM
Light up the dance floor with Volumo, the largest catalog of electronic music. Search, listen and download the music of your favorite artists on https://volumo.com
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO