Collaborate on Invoice Sending Mail Format for HR with Ease Using airSlate SignNow

Invoice sending mail format for HR

in this video you will see how to mail merge on Outlook desktop we have a white document here with the letter we want to send to a list of people which we have in this Excel document let me clarify we cannot do the mail merge on Outlook we need to create the mail merge document on Microsoft Word and it will send the emails via Outlook itself and for the list of contacts we can use Excel spreadsheet or we can use the Outlook contacts as well so here in this video I have the list of contacts in an Excel spreadsheet with the related columns and here in the word document the later contains two placeholder with the text here s and we will replace this with the Excel spreadsheets name and publication name on the word document click on the mail links menu and select start mail merge from the list of option select email messages now we will import the contact which we have in the spreadsheet click on the select recipients and select the use an existing list option open the file with the contacts I have it here and open it here you will see the worksheet name since our contacts top row contains the header so we will keep this option checked and click on the OK button now we will fill the placeholders this and this on this later with the content from the Excel spreadsheet we just imported first we will put the first name here let me me delete this now here select insert mail merge field and select the first name before inserting any image mail merge field make sure that the mouse cursor is there where you want to insert the field so let's insert first name and I want to add the last name as well so I'll give a space and again I want to add the last name here and a comma Now I want to add the publication name here where the placeholder text is so I am deleting this text here and put the mouse cursor here and again go to insert merge field and select publication we are ready with the letter to preview it click on the preview results option and you will see how it looks you see the first name last name and the publication name here John news you can use these arrows to navigate to the previews for The Other contacts you see it here let's send the email now here click on finish and merge option and select send email messages here select the email address field where all the email addresses for all the contacts are for us it is in the email column right and it has detected automatically and now let's create a subject line for the email I am adding Outlook mail merge via word test and mail formatted HTML and we will send the email to all the records we have so I will keep this selected all and click on the OK button we are done if you open your outlook and check your sent items or outbox because the email messenger are just now sending so you see the email message are now sending so now we can check them on sent items as well so you see all the email messages example example example and here is the list we have with all the email addresses and we just send and let's check the email message how it looks this is the mail merge document we have and this is the email message so we are done unfortunately we cannot send attachment when sending emails with the default mail merge from Microsoft Word I will create another video on how to send attachment with mail merge from Microsoft Word so don't forget to subscribe to the channel please like the video and share it with the people who may need it thank you for watching [Music]