Merge Electronically Signed Protocol with airSlate SignNow

Send Sign Word Easy

hi everyone my name is Kevin and today I'm going to show you how to do mail merge using Word Excel and Outlook so first off what is mail merge we'll think of it as when the electric company sends you a bill every month they customize your bill with your name your address information I'm going to show you how to do something similar to that let's say you want to send out envelopes let's say you want to send out a letter or maybe you want to send out an email and each individual one has custom information that you want to include on there that's what we can do with mail merge so let's jump right on into it and as we're getting started here just as full disclosure I work at Microsoft okay so what I'm going to do first is I'm going to open up Microsoft Word so we're gonna pop up word here and then I'm gonna open up a new blank document um so here I am in my new blank document and what we're gonna do is we're gonna click on mailings now one thing to say is this what I'm using right now this is office 365 chances are it'll also work on 2019 2016 2013 2010 I don't think mail merge functionality has changed that much but just as a caveat this is using the latest version of Office this is office 365 so I'm gonna click on mailings and the first thing I'm going to do is there's a little button there that says start the mail merge I'm gonna go ahead and click on that and today what we're going to do is we're going to create an email message that I'm going to use to customize the user information in there you could also create things like letters envelopes labels directory information but we're going to do an email today the the process that you follow on all these other ones is very similar it's doing an email message so I'm going to click on that and like I said before I'm gonna be sending out a billing notification so I get to collect money from people so we're gonna say hello and I want to customize this so what I want to do is I need to select information now let me pull my word document over and here on my desktop I have a sheet called customer information so I'm gonna pull that up this is a spreadsheet that I created ahead of time and it has four different columns it has the first name of people it also has the the planned name that someone is on it has the the due date for the bill and it also has the email address I just use the same email address on each one and so I want to use this information from this list in the the mail merge that I'm doing so we're...