Bulk Draft Email Signature with airSlate SignNow

Bulk draft email signature

hello this is coming from extremist or group today you will see how to send emails through Excel will be using Outlook to send emails so if you look at here we have a list of email subject and messages which we are going to send to your ex oh so first of all we need to check references and so by default we have libraries for Visual Basic and XO and other default libraries but we are going to use functions for Outlook so we need to include the object library for Outlook so once we include it we start writing our supposition they call it as a send email all right so now first of all we need to declare the object for Outlook application because we are going to use that application so Tim will app as output application then we need to declare an object for the mail item that we are going to use here so the hierarchy is like this at the top level we need to first open the application and then after application we need to create the mail item and then we'll be sending that email or will be color setting different properties of that email so so I am now getting an object here so set well up equals new output application and my mail item would be I am just creating an item under it so will after create item and that mail item comes here in the list it close the bracket like this so now once I type whole mail I will see all the functions or all the stuff related to that particular object so like this to mail dot-to-dot TC touch object I can see phase properties and for message I can use body and if I want to send this message I will be using dot send or if I just want to see that message I will be using well mail dot display so on and so forth but now you will see that I'm using that object name over and again so instead of typing it like this I can just include a web block and close it here and then I don't require I don't need to type it again and again here I can just put a dot and then the property all right so let's fill in these properties so dot two is the so if I go back to my excel file I have recipient name and subject and message three properties if I first hardcore that I can directly put it like this then I will be configuring it according to that file and I will put that inside a loop so that repeat itself a number of times as many entries I have in the excel file so I have set all the properties now once I created item I will now set my mail item in the Outlook application item to nothing right now let's run it let's see what happens that in the background it'll be creating an instance for Outlook application then it will create a mail object and it will set to subject and body properties and then it will display it to me if I have used a dot sent it could have sent that message to that particular recipient so R is on right now let's close it and let's see how we send it to multiple users which I mentioned in the list it doesn't need anything pocket-sized what I need to do here is I just need to remove these things all right I just need to put a follow here on the top so for I equals to two because my rules are starting from two and these are up to let's say for right now but I will be again making it dynamic later so initially I let's say I put it as four for I equals two to four and here I will close my loop and now I don't want to put in these two and these properties directly instead of that I will be using my counter to pick that value who says I from a wonderfully 4 2 comma 2 dot values for CC subject and comma 3 sore body now arrived on it initially when I would be two people great message for first row and then the valley or I would be three and it will generate a message for third row and so on and so forth it's where if you see it opens up three different messages and that's all now one more thing we won't be hard coding the number of entries because today we know that these are three items so I for two to four but tomorrow user may enter 100 different rows so instead of hard-coding are we making a generate so because these data is in sheet 1 so a reason if sheet 1 dot cells so to get the last available row I will go to the last row of pixel load count comma 1 for first column only and then I'll come back so dot and X laptop row it gives me a last cell that is having data in Excel first column right so it will now run for all the rules even if I put data for 10 different 10 more rows it will automatically detect a row and send it for follow me all the users well this is pretty much so if you have any further questions or conclusions regarding Outlook email you can write to me at Excel dot macro P at gmail.com goodbye