I'm going to show you how to mail PDFs to a list of email addresses that you
have in Excel this is basically the same file that I used for a mail to a list
for doing word documents but I asked this question a lot so I thought I would
make a video of it so basically we have our list of it email addresses here we
have our list of files that we are going to attach and right now these files are
PDFs basically if we go through the code I have set some parameters dim as each
address as a string subject is a string message as a string file name as a
string outlook app as an object Outlook mail item as an object my attachment as
an object path as a string and last row integer attached attachments as a string
and X as an integer okay so I'm saying while x equals 2 because
our heading rows here and then we're we are setting well X 1 does not equal
blank then set out look to create outlook object create Outlook
application Outlook mail item equals outlook app don't create item 0 set my
attachments equal Outlook mail items attachments path see user so basically
what I've done is I have I've brought up my my file folder where these things are
put I've clicked in here and now you've got the path by clicking in there and
copying it so you see that I have both word and PDF saved here so now so that's
basically where I've got my path from don't forget to put the the final
backslash and put that all in quotations address equals whatever is ii-in
whatever is in here is our e address okay
attachment attachment equals path and filename so the path that we've selected
here and the file name the file name equals sheet one cells the cells that
whatever you have here it can be PDFs it can be Excel files it can be anything
okay as long as you have it specified in here you can attach anything you want to
these to these documents to these emails set this all up when we go out look male
let m2 equals e address which is our email address Outlook and then we have
nothing for a carbon copy or a blind carbon copy the subject the subject
equals the cells that we have right here and then it says we have a little
message in our email address that says please find attached to your statements
your statements attached and then best regards so now and then it loops through
that and when it's finished the loop it says so set outlook app equals nothing
and set Outlook mail equals nothing so let's run this so basically now I'll
open up my Outlook and outbox and there I have I have my first email sent to
screaming acres and the subject is 1 2 3 4 5 and I have got attached the PDF so
this is basically showing you that you can put any type of attachment that you
want including PDFs in this in this in the excel file you can attach anything
you'd like here so that's how you send it in send a PDF as an attachment to a
mail to an email list please subscribe