Send Recipient Title with airSlate SignNow

Merge letter signature

welcome to carefree int TV today we will be talking about mail merge mail merge is a feature that we use to create personalized letters and pre addressed envelopes or mailing tables to mass mailing from a form of letter that or a standard template or a word processing document in simple words if you have supposed more like 2000 people you want to send one newsletter to or maybe some letter or you want to create mailing labels for more like numerous people say hundred or thousand addresses that you need to create there is a simple way to do that in Microsoft Word using the mail merge feature all you had to do is just create an excel sheet with the list of contacts with your addresses and you can create a letter in the word and you can personalize each letter with the contact from the excel sheet we will see that in a minute how we do that let's open would you go to me link and start mail merge there are different forms that you can create neck letters email messages and wallops labels or directories that a tree me or will do see that one by one but initially we'll start with the mail merge wizard which is a simple way of creating that on the right hand side corner you will see the mail merge task menu you've um here you can specify what kind of document you want to create is it a letter or it's an email message or personal email full all the contacts that you will be selecting from your Excel sheets or maybe a different database database and Mallove's mailing labels directory directing will be a single document that contains a list of addresses or or whatever you specify in your Essen sheet so let's create a simple letter this is my step 1 I go to sad document now you can use a current document maybe even just type in some stuff you can use this as a document just a plain document and you can type in anything you can start from the templates which are readily available to schools select the template we are doing the letter so let's go to letter and I'm just picking up the first one randomly let's say ok or you can just start with the existing document so let's say you have already created the document you can just open that document and go to the mailing and you can start milling the merge wizard I go to my next step where I'll be selecting my recipients um you can use existing list if you have created any even just browse through or even maybe if you have an excel sheet or a CSV document where you have all the contact list of the people who you want to send this letter to you can pick that up here or you can select the Outlook contacts you can it will directly connect to your Outlook contacts list and you can pick up any one so I can go with the might has contacts or my contacts then oh the ones which I have in here I just say ok so it will pick up all the four contacts that are there in my Outlook or you can just create a new list right here so you can type the name first name nothing that's by default you can customize these columns let's say you don't want title you don't want address line 2 and you don't want their home phone number let's say they are all from the same country so you don't want country even in the address list and on zip code room and if you want to add something you can simply add and type in the name of the field and that will be added in this list let's say I have first name last name company name the city the work phone number and the email address so I can type in some names and you can create multiple lines let's say okay and you can save this list on with the name let's say my contacts so now my contacts dot MVP database has two names and you can shuffle them around for example if you want first name to appear first you can move it by just dragging and dropping it here and you can customize the layout suppose you want to block phone number before the email address you can do that and if you want to sort this list or you can do that too based on the first name last name and in so you can pick up what is the criteria of sorting them you can filter on some addresses in order to send the emails let's say you are picking it up all of that and we go next here we can customize our ledger let's say I don't want the recipient name on the senders address here I will just delete the spot and let's say after my name I want the address block where it's the recipients like let's say name and then their company name and they're all sitting if you want you're gonna add more to it from here you can pick it up and I'm good with it so just say ok now I can delete this part and let's say I want my greeting line here say dear Stephanie comma you can change it with Colin or leave it like comma or you can pick and store Stephanie or if you want to type in your own personalized message you can do that I'm good with defaults you can change this letter you can customize it as for the content of your own letter that you are planning to just design you can get rid of this and let's say thanks I can delete this part and this goes as carefree I once I'm done with this I can go to preview the letters and this is how my little would look to my different recipients so my first recipients of second recipient was Stephanie and the first one wants to know if you want to modify any a particular recipients letter you can do that from here as well and on if you want to add more recipients to it you can simply add it the recipient list right here just go to database say add it and you can add more names to it to say new entry so if we just create another roofie filled row for you you can create more entries in here say okay once you're done and then you can just go with a complete didn't merge here you get the option of either print or you can edit them so you can edit the individual documents you can drink them or maybe even to send the evening messages let's say we pick the send the email messages to the email address that I specified in my contact list and if you want to send it to just one or two recipients you can specify that say I just wanted to present to one recipient I can say that if you wanted to send to the first ten recipients you can do that or if you want to send it to all you can pick all option and if you want to just send it to the one which you are picking in here so you can pick up the current record let's say all and say okay so this one doesn't have a something I'm you care I didn't add one subject but you can definitely do that and say hence anywhere now this will send an email to all the recipients that were in my contacts list I had to so it sent email to two of them okay let's go to my outlook and see if this is recede so it is received a tutorial at carefree ID dot C and here is the letter now besides this you can also go without the mail merge wizard so you can start the mail merge you can pick up the letter you can pick up this recipients just type in a new list or use the existing list let's try the D use the existing list all before that let's create a list I have my exit open let's say I have me company name and city and in the address so I can randomly type Latino John here free okay city one low and let's say email John Q 380 dots a let's say click on turn three okay and say hey take city under the hood which are in here let's say I'm just copying the same thing again goal it dragging you go to the right hand side bottom corner then you see class just drag it and then you copy the entry look and let's say I cannot see okay so now I have five contacts in here I can save this let's say on my desktop and I named it as company contacts let's say say no I can go to the existing list select different lists go to my desktop and see company contacts and say ok so this will bring in my sheet with all the contacts I just created you can shuffle around and just say ok so I have five recipients I call the day you can go from here like next or maybe you can just pick up the address block greetings the babies saw in the mail merge visit you can pick them up from up top here and in the end you can just save finish and send email numbers and the emails to all the recipients or if you want to add it into your documents you can say ok and it will show you all the letters so this one is shown on the same page would be Anita third one is and fourth one and this one so it's going to give you the list of all letters you can do to retype customize that today you want to and in the end you go to make and place the mail merge document so you just say send emails or if you want to print in segments and so on besides that you can also do the email messages you can also do the envelopes the address messages on the envelopes you can do mailing labels or you can just create a file with all the addresses from a border from your excel sheet so this summarizes our mail merge today and in the next series we will be talking about transition from windows 7 to Windows 8 and some really cool features of Windows which are generally are not very much famous stay tuned for our next tutorial next week and have a good day