I'm going to show you how to send custom emails from a list in Excel
so here I have two emails and I'm assuming the only example I could think
of off the top of my head was somebody who sold cars and so at the end of the
month they're gonna send it a congratuitory email to the people that sold car
if they sold cars too and so in the for your first field we have this is charlie
brown's email so obviously fictitious and Mickey Mouse's email then we have
the name Charlie Brown and Mickey Mouse and what they purchases Charlie Brown
bought a 2018 VW and Mickey Mouse bought around 1,500 truck and the terms of the
repayment are 36 months for Charlie Brown and 24 months for Mickey Mouse so
let's show you the code so I've started I'm doing this through outlook and I've
set a address is a string subject is a string message as a string outlook
outlook app as an object outlook mails an object X is an integer and andro as
an integer the subject is name purchased and terms
are all strings so I've defined the and row as the current Regis row count so
we've tried this going to how many rows we have in there and I'm doing a for
loop so I'm going for 2 from 2 which I have heading rows so I started at 2 2
and row and now I have I'm creating an Outlook application and said ìlook
application into outlook creation create item 0e dress is my sheet x1 and then I
say and then like all my emails will say congratulations on your new purchase and
that's the subject and the name is what's going to be in the letter so it's
gonna say so the name is sheet sheet 1 cells x2 so that's there and purchased
what they bought is the VW right here of purchased is in the x3 and
the terms is in x4 and so that's what I have defined here now what I've done in
the body what I've said is congratulations and
name so I've put congratulations than in my name field and then I've got this is
a symbol for a carriage return and then I say thank you for your purchase and
then and then we have the field purchase that I've entered in that the fourth
column or third column and then I say we hope the terms are now hope we hope that
your repayment and then the terms which is a 36 or 24 months will be suitable
for repayment and then I have a carriage return character turn you have any
questions do you know it hesitate to call and then I have the salesman car
sale or car salesman as a signature now you could fill in anything here you can
write whatever you want and have your fields that are going to be customized
for each email right in there so then we turn Outlook Outlook mail item to in the
e address and the subject as subject and then what I've done here is that Outlook
email item display so you can see it and I've put a quotation or quotation mark
in front of the Outlook sin so that it's not sending but when you do that you can
take that off and it will send automatically application display alert
it's true set outlook app to nothing set Outlook
mail item to nothing and then we're going Next to continue our for loop and
then I go and some so let's run this and I'll show you what it looks like so I'm
going up here and pressing this make sure I'm at the top and then I'm
pressing my run and so there we have our two emails so I say congratulations
Mickey Mouse for your purchase of the RAM 1500 truck we hope that your 24
months will be suitable for repayment and we have your questions do not
hesitate to call and then the sales person and then I have for Charlie Brown
I have congratulations Charlie Brown thank you for your purchase of the 218
BW and the 36 months will be suitable and same thing so that way you can you
can send you can send many emails and you can make them all customized from
the fields that you have in Excel I will include this code in my description
please subscribe