Sibeesh Passion

Top Menu

  • Home
  • Search
  • About
  • Privacy Policy

Main Menu

  • Articles
    • Azure
    • .NET
    • IoT
    • JavaScript
    • Career Advice
    • Interview
    • Angular
    • Node JS
    • JQuery
    • Knockout JS
    • Jasmine Framework
    • SQL
    • MongoDB
    • MySQL
    • WordPress
  • Contributions
    • Medium
    • GitHub
    • Stack Overflow
    • Unsplash
    • ASP.NET Forum
    • C# Corner
    • Code Project
    • DZone
    • MSDN
  • Social Media
    • LinkedIn
    • Facebook
    • Instagram
    • Twitter
  • YouTube
    • Sibeesh Venu
    • Sibeesh Passion
  • Awards
  • Home
  • Search
  • About
  • Privacy Policy

logo

Sibeesh Passion

  • Articles
    • Azure
    • .NET
    • IoT
    • JavaScript
    • Career Advice
    • Interview
    • Angular
    • Node JS
    • JQuery
    • Knockout JS
    • Jasmine Framework
    • SQL
    • MongoDB
    • MySQL
    • WordPress
  • Contributions
    • Medium
    • GitHub
    • Stack Overflow
    • Unsplash
    • ASP.NET Forum
    • C# Corner
    • Code Project
    • DZone
    • MSDN
  • Social Media
    • LinkedIn
    • Facebook
    • Instagram
    • Twitter
  • YouTube
    • Sibeesh Venu
    • Sibeesh Passion
  • Awards
  • Linux Azure Function Isolated Dot Net 9 YAML Template Deployment

  • Build, Deploy, Configure CI &CD Your Static Website in 5 mins

  • Post Messages to Microsoft Teams Using Python

  • Get Azure Blob Storage Blob Metadata Using PowerShell

  • Deploy .net 6 App to Azure from Azure DevOps using Pipelines

Microsoft OfficeOffice 365Office Development
Home›Microsoft Office›Mail Merge in Word 2013

Mail Merge in Word 2013

By SibeeshVenu
March 29, 2015
1153
0
Share:

Introduction

document1
document2
output
Hi all, in this article you will learn about mail merging in Word 2013. Most of you may have already worked on this, or familiar with it. This article is for those who have not yet tried this.

Background

Yesterday one of my friends asked me about mail merging in Word. To be frank, that was the first time I had heard about it. I then learned it is a feature available in Word. But I could search and help my friend about that. So I thought of sharing that info with you all.

Mail Merging in Word

The Mail Merge feature helps you to create Word documents with nearly the same contents with only a few differences. Let us say you have to send your marriage invitation Word document to 100 people. In this case, only the address will be different, right? (I know you won’t create your marriage invitation in a Word document. This is just for an example.) So here we can use the mail merge feature.

How it works

We will have two Word documents. The first document will have the address details of the recipients. And the second document will have the marriage invitation content. So what we are going to do is, just gathering the data from the first document to the second. At last we will have a separate marriage invitation for the separate address.

Let’s start

We will do the entire process step by step.

Step 1

Open a sample Word document.

Consider that we have the first document, document 1, as in the following (please see the document1.docx from the download list).

Mail Id Name Address
Sibikv4u@gmail.com Name1 Address1
Sibeesh.venu@gmail.com Name2 Address2
info@sibeeshpassion.com Name3 Address3
sibeeshkv@yahoo.com Name4 Address4

NB: The most important thing here is, I have used a comma (,) as the delimiter. To work with this feature we must give a delimiter (separator) in each of the details.

Step 2

Create invitation Word document.

Consider we have the content (document2.docx) as follows.
……………………………………………………………………………………………………………………………………………

From,
Your name,
Your address
To,

With joy in our hearts, we your name and your fiancée name, request the honor of your presence as we exchange marriage vows and celebrate our new life together Saturday, June 19, 2015.

The Taj Hotel

Chennai

————————————————————————————————————————–

Please note that I have not given the “to address”, this content we will gather from the document1.

Step 3

Open document2.docx and click on start Mail Merge under the mailing tab.

Click on the step-by-step Mail Merge wizard. Now you can see a dock panel on the right side of your Word document as follows.

Step 4

Click on the Next: starting document in the bottom side.Select use current document as in the following image.

Click on Next.

Step 5

Click on the browse link and load the document1 document.
After doing the preceding, you will get a screen as follows:

Please note that all the details are loaded correctly.

Now click OK.

Now you are able to write your letter. Click on write your letter as in the following image.

Step 6

Click on the more items from the next panel window.Once you click that, you will get a pop up as follows with the items in the document1.

Step 7

Add the fields to document2.Now all you need to do is to select the fields. Just click on where you want the fields and select the field you want to be placed and click on insert. Please note that the reference has been loaded depending on the document2 area.

Step 8

Click on Preview your letter and complete the merge.After doing that, you will get a screen as:

Click on the edit individual letter. And click OK for the next pop up.

Now you can see the invitations separately for each of the names and addresses you have given in the document1.

That’s all.

Output

Please download output.docx to see the output.

Conclusion

I hope you liked this article. Now please share your thoughts and suggestions. It matters a lot.

Kindest Regards,

Sibeesh Venu
www.sibeeshpassion.com

TagsMail MergeOffice Development
Previous Article

Learning AngularJS: $http

Next Article

Load Contents From Text File using jQuery

0
Shares
  • 0
  • +
  • 0
  • 0
  • 0

SibeeshVenu

I am Sibeesh Venu, an engineer by profession and writer by passion. Microsoft MVP, Author, Speaker, Content Creator, Youtuber, Programmer.

Related articles More from author

  • Microsoft OfficeOffice 365Office Development

    How to delete a blank page in Word

    July 18, 2015
    By SibeeshVenu
  • Microsoft OfficeOffice 365Office Development

    How to Consolidate Data in Excel

    January 29, 2015
    By SibeeshVenu
  • Office 365

    Why Office 365 Calendar Permissions Not Working- Solution

    February 20, 2018
    By Ashish Ratan Singh
  • Office 365SharePoint

    What is SharePoint? Explore its Top 10 Benefits & Advantages

    April 21, 2017
    By Ashish Ratan Singh
  • SharePoint PnP Provisioning Commands
    Office 365SharePoint

    SharePoint PnP Provisioning with Data – Move Your Contents from One Site to Another in SharePoint Online

    November 6, 2018
    By SibeeshVenu
  • AzureCognitive ServicesOffice 365SharePoint

    Azure Form Recognizer and Microsoft Flow to Search Scanned PDF Content in SharePoint Online

    March 5, 2020
    By SibeeshVenu
0

My book

Asp Net Core and Azure with Raspberry Pi Sibeesh Venu

YouTube

MICROSOFT MVP (2016-2022)

profile for Sibeesh Venu - Microsoft MVP

Recent Posts

  • Linux Azure Function Isolated Dot Net 9 YAML Template Deployment
  • Build, Deploy, Configure CI &CD Your Static Website in 5 mins
  • Easily move data from one COSMOS DB to another
  • .NET 8 New and Efficient Way to Check IP is in Given IP Range
  • Async Client IP safelist for Dot NET
  • Post Messages to Microsoft Teams Using Python
  • Get Azure Blob Storage Blob Metadata Using PowerShell
  • Deploy .net 6 App to Azure from Azure DevOps using Pipelines
  • Integrate Azure App Insights in 1 Minute to .Net6 Application
  • Azure DevOps Service Connection with Multiple Azure Resource Group

Tags

Achievements (35) Angular (14) Angular 5 (7) Angular JS (15) article (10) Article Of The Day (13) Asp.Net (14) Azure (65) Azure DevOps (10) Azure Function (10) Azure IoT (7) C# (17) c-sharp corner (13) Career Advice (11) chart (11) CSharp (7) CSS (7) CSS3 (6) HighChart (10) How To (9) HTML5 (10) HTML5 Chart (11) Interview (6) IoT (11) Javascript (10) JQuery (82) jquery functions (9) JQWidgets (15) JQX Grid (17) Json (7) Microsoft (8) MVC (20) MVP (9) MXChip (7) News (18) Office 365 (7) Products (10) SQL (20) SQL Server (15) Visual Studio (10) Visual Studio 2017 (7) VS2017 (7) Web API (12) Windows 10 (7) Wordpress (9)
  • .NET
  • Achievements
  • ADO.NET
  • Android
  • Angular
  • Arduino
  • Article Of The Day
  • ASP.NET
  • Asp.Net Core
  • Automobile
  • Awards
  • Azure
  • Azure CDN
  • azure devops
  • Blockchain
  • Blog
  • Browser
  • C-Sharp Corner
  • C#
  • Career Advice
  • Code Snippets
  • CodeProject
  • Cognitive Services
  • Cosmos DB
  • CSS
  • CSS3
  • Data Factory
  • Database
  • Docker
  • Drawings
  • Drill Down Chart
  • English
  • Excel Programming
  • Exporting
  • Facebook
  • Fun
  • Gadgets
  • GitHub
  • GoPro
  • High Map
  • HighChart
  • How to
  • HTML
  • HTML5
  • Ignite UI
  • IIS
  • Interview
  • IoT
  • JavaScript
  • JQuery
  • jQuery UI
  • JQWidgets
  • JQX Grid
  • Json
  • Knockout JS
  • Linux
  • Machine Learning
  • Malayalam
  • Malayalam Poems
  • MDX Query
  • Microsoft
  • Microsoft ADOMD
  • Microsoft MVP
  • Microsoft Office
  • Microsoft Technologies
  • Microsoft Windows
  • Microsoft Windows Server
  • Mobile
  • MongoDB
  • Monthly Winners
  • MVC
  • MVC Grid
  • MySQL
  • News
  • Node JS
  • npm
  • Number Conversions
  • October 2015
  • Office 365
  • Office Development
  • One Plus
  • Outlook
  • Page
  • PHP
  • Poems
  • PowerShell
  • Products
  • Q&A
  • Raspberry PI
  • React
  • SEO
  • SharePoint
  • Skype
  • Social Media
  • Software
  • Spire.Doc
  • Spire.PDF
  • Spire.XLS
  • SQL
  • SQL Server
  • SSAS
  • SSMS
  • Storage In HTML5
  • Stories
  • Third Party Software Apps
  • Tips
  • Tools
  • Translator Text
  • Uncategorized
  • Unit Testing
  • UWP
  • VB.Net
  • Videos
  • Virtual Machine
  • Visual Studio
  • Visual Studio 2017
  • Wamp Server
  • Web API
  • Web Platform Installer
  • Webinars
  • WebMatrix
  • Windows 10
  • Windows 7
  • Windows 8.1
  • Wordpress
  • Writing

ABOUT ME

I am Sibeesh Venu, an engineer by profession and writer by passion. Microsoft MVP, Author, Speaker, Content Creator, Youtuber, Programmer. If you would like to know more about me, you can read my story here.

Contact Me

  • info@sibeeshpassion.com

Pages

  • About
  • Search
  • Privacy Policy
  • About
  • Search
  • Privacy Policy
© Copyright Sibeesh Passion 2014-2025. All Rights Reserved.
Go to mobile version