I'm going to show you how to send different messages to each person in a
list and what you're doing is you're selecting which letter you want to send
each individual you have your email you have your subject now I'm not I'm not
doing the attachment but um this is where you're selecting the body of the
letter that's going to be on each message so this is answering the
question hello barb thank you for sharing your videos I just saw anyone
made on 2017 I'm doing that project that when I wonder if you can help is it
possible to send emails from Excel and be able to choose which email template
to use and so that's what I'm doing here and so how I've done this is I've simply
gone to the data tab I go to data validation and then I chose list and I
just put simply put in letter one letter to letter three and once you've entered
those in you are you're able to grab the fill handle and drag it down so now you
can select you can click on this and select any of the letters that you want
so what I'm going to do is I'm going to run this and show you how it looks so
I'm going to macros and I've called it send different from different mail from
email or from Excel so let's go run and I'm having the messages display and so
here you go one messages thank you for your contract
and the second message says please please review our proposal for your
tender and the third third is please thank you for your contract will we do
the results so there's three different messages here and we have selected them
by selecting letter one two or three now let's look at the code so what I have
here is I've I've defined all my variables I've doing E
message subject message and when I come down be here I say body one body to body
three is strength and as I go I'm going down the list doing I do while loop I'm
setting at x equals two because I have header rows and the outlook app create
Outlook application Outlook mail and then then I've so what I've decided what
the bodies are gonna be so body one is thank you for your contract body 2 is
we've completed your work and body 3 is please view our proposal for your tender
and whatever you need to say with that and now II address is sheet 1 cells x1
so that's the first column the subject is x2 and then if sheet 1 cells x4 and
that's where I have the drop-down list for the letter that you're selecting if
it's letter 1 and the message equals body 1 else if sheet 1 cells x4 value
equals letter to then message equals body to else message 1 equals body 3 so
then I do a 2 n dips and then I send my email as I was saying I have I have the
code in here for sending an attachment with it it's just from previous stuff
that I've done so I will include it this code will be included in in the
description of my video so this is how you send different messages to different
people on your list please subscribe