00:00Here is how you can organize and send email to everyone in your company with a single click.
00:04In my worksheet I have a list of employee names and their associate email address. On the right
00:09hand side of the worksheet I have an email template that I want to send to all these email
00:13addresses. We're going to start off by using a hyperlink function and the first argument is
00:19basically a structure or your body of your email. So basically we're going to start off with the
00:25URI schema which is going to be mail to. And then mail to will always be followed by the email
00:33address. My email address for all the employee runs from C3 to C44 and I'm going to concatenate that
00:40with the second part of the body which is my subject itself. Subject equal double code and
00:49basically concatenate that with the template subject which is the sun in F11. Concatenate
00:55and the next one I'm going to introduce will be the body itself. Equal and the body for the body
01:03let's start off with saying hi space and then we're going to put the employee name. Concatenate the
01:10employee name which runs from B3 all the way down to B44 and then concatenate that with a comma. So
01:19basically saying hi Claire comma space double code. Concatenate that with the body message from
01:27my cell at F13 here like this. And we're going to concatenate that with a CC
01:36and CC equal and we're going to use the CC from our template here again which is going to be
01:43this
01:44one here on cell F25. And that completes your very first argument on your hyperlink. Now this second
01:51argument on the hyperlink is basically a clickable text. We're going to call it send email like this
01:59close parenthesis like this. And if you hit enter you can see that this clickable text is essentially
02:06whatever you typed in here. Let's ensure that the clickable text format is similar with the rest of
02:11row. Go ahead and select the very first cell in D3 self. Click on format painter from the home ribbon
02:20and then select all your rows like this. And now all the clickable text looks the same. Now if you
02:28click
02:28any of this send email here like this you'll open up your outlook and then basically create your email
02:36ready to be sent. Now I got a quick quiz for you here. Does anybody know what does percent OA
02:42actually
02:43do in our body? Leave your answer in the comment section below.
Comments