I'm going to show you how to put a hyperlink in the body of an email that
you're sending from Excel this is a problem that I was having producing an
email for a course that I'm teaching and I used HTML as the body of my email
because I have a large graphic that's included in my email and I has having
difficulty in producing a hyperlink to register within the body of the email
and so came up with a solution and so what I'm gonna do is I am going to run
this you can see that my two people on my on my mail out or Fred Flintstone and
Barney Rubble and so what I'm gonna do is I'm gonna run this code and so then
you get two emails I have them displayed as opposed to sent and so then here I
get I have hello Barney and then I have my click to register here and if you can
see that that when I mouse over it it is truly a link and then I have my large
graphic on the bottom so let me explain the code how it works the declarations
are the same email address subject is the string message as a string and we go
all the way down I have put also name as a string and string by string body is
because I'm doing it in HTML and so I need to have a little bit different
things happening here and so then we have I have a do-while and x equals to
do while sheets one column one way with email addresses away until they don't
have anything in them set outlook app Outlook mail and then were then I say
name equals sheet one cells column one and E
a sequel sheet 1 column 2 and filename is the big graph of them attaching on
the bottom is called traditional dot jpg okay so here is my string body and this
is where my HTML is I have hello and then I have so this this is going to be
its we have a greater than sign a BR and a less than sign because I am NOT able
to put greater than or less than in the description of my video when I include
the video in my code I will just have spaces for where there's a greater than
a less than here so basically I have opening opening break hello
and then I have an and and then I have the name so that it's nice that can
include the name okay then the rest is all pretty the same and now I go into
the bottom here and I from for my condition for my hyperlink I go click
href equals and then equals and then I have a purse and a quotation and an
ampersand and for quotation marks and another ampersand and then I have the
link with quotations around it and then if I scroll across once again I have an
ampersand for quotation marks and and a quotation mark a greater than sign I
will not be able to include this greater than sign in the in the description of
my video and then I have here to click here to register for my graphic that's
large what I do is I have I have image source conditional formatting and I have
the path further up there and then I say the graphic in this display how big I
wanted to have it and frame two is my conditional formatting subject upcoming
webinar and then it says and then it's basically no CCS no B C's subject is
upcoming webinar attachment is add path and file name to filename to being my
large graphic body and HTML string equals string body
plus break and dot HTML and dot display if you wanted to send it you could just
have a dot sent here instead and then end with address equals nothing x 1 x
equals x plus 1 and then we go to our loops i'm gonna do while when it's done
the loop it says set outlook app to nothing and set Outlook mail to nothing
and sup so that's how you create a
hyperlink in your email body that's said from Excel now I will include the the
code in this description please please note that I am once again I'm lemon did
not have being able to put these opening and closing brackets on my description
so you'll have to add them yourself and that this is how you do it please
subscribe