Macro To Send Emails with PDF: Multiple Emails and PDF's

**totoga12** · 03-18-2014, 03:57 PM

Hi Everyone!

I need help creating a macro that will Email PDF's to multiple people with the PDF
file that corresponds to them.

I have 3 columns in Excel 2010: Column A has stores( 10 stores), Column B has store manager(10 managers), Column C has Owner of stores(3 different owners of the 10 stores).

I would like to execute a macro that email through Outlook the 10 different managers with their PDF
that corresponds to them. The PDF's are already created and located in a folder.

I appreciate you help!

**judgeh59** · 03-18-2014, 04:05 PM

this might help. call this sub with the ToNAme (managers name), SendFile (PDF File Name)

Please Login or Register  to view this content.

**totoga12** · 03-18-2014, 04:33 PM

Thank you for the quick reply. Is there a way to loop through each manager instead of typing their
names? Perhaps adding a range?

**judgeh59** · 03-18-2014, 04:36 PM

well, without seeing your code here is the basic idea...you'll have to set LastRow....I can show you how if you need that....

Please Login or Register  to view this content.

untested

**totoga12** · 03-18-2014, 05:08 PM

Thank you. If you don't mind showing me. I will be using your macro. Where should I insert the last vba you entered?

Thank you

**Jim885** · 03-18-2014, 05:11 PM

Try this. It will send emails to every address contained in column B (to the last row). As well as column C (if you need)

Please Login or Register  to view this content.

**judgeh59** · 03-18-2014, 05:12 PM

where you insert this code into your macro is hard for me to say with seeing your code....I would assume it's pretty much the last thing you'll do in the macro

Please Login or Register  to view this content.

**totoga12** · 03-19-2014, 10:33 AM

Thank you judgeh59

**totoga12** · 03-19-2014, 10:47 AM

Jim 885,

The macro works great. Only one more request please.

I have a 4th column which is the name of the file for that manager. Can I send the file in the directory
that corresponds the file name in column 4?
(Ex.) The email will send to Column B(Manager), CC Column C(Owner),use the name in Column D(ABCDE.xlsx) to find the file in the directory folder("C:\Users\"). Send

**totoga12** · 03-19-2014, 03:09 PM

I'm VERY close to completing the macro. The only issue is column "D" which contains the file
path is not iterating to the next cell below like column "B" and "C". Meaning the file attached to the e-mail
is not finding the next manager and its staying on the first cell.
Please help

Please Login or Register  to view this content.

**judgeh59** · 03-19-2014, 03:28 PM

I'm a little confused --- you say Column "D" isn't incrementing but you are looking in Column J (10) for the attachment....so StrAttachment = ...cells(i,10).value...when I step through your code with some dummy data it seems to do what I would expect...

now the .Attachments.Add .... is not using strAttachment at all which could be an issue...

**totoga12** · 03-19-2014, 04:06 PM

Sorry. I was trying to keep the question basic. I should have used my actual info.

The actual columns on my excel sheet are: Column G(Is an ID), Column H(Manager email),Column I(Owner email), Column J(folder path for file-C:\Users\ABCDE.pdf)

Thank you

**judgeh59** · 03-19-2014, 04:11 PM

excellent --- so the

.Attachment.Add still doesn't use the strAttachment variable and therefore is probably not picking up the change when "i" is incremented....

Please Login or Register  to view this content.

this is untested

**totoga12** · 03-19-2014, 04:28 PM

Works great! Thanks for everyone's help!

**judgeh59** · 03-19-2014, 05:10 PM

Please remember to set the thread to Solved...If you feel we deserve an increase in our reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be one of us..just a thought...

**Jim885** · 03-19-2014, 06:11 PM

The code I gave you provides a way to make each of the emails personalized to an intended recipient with the highlighted part of this line;

Please Login or Register  to view this content.

I'm going to assume that you have the recipient’s name (or company name) (not email address) in column A so that the code works as intended.
Otherwise you can change the '(i, 1)' to whatever column the recipient’s name is in. Whereas, 1 = column A, 2 = column B, 6 = column F ... you get the idea (number = column)

It was easier working with you than with most other people. You understand more than some of the others who need step-by-step assistance.

Glad we helped make your life easier.

Please mark this as SOLVED if you don't need anything else.
Thanks.

**judgeh59** · 03-19-2014, 06:13 PM

I defintely agree with Jim885

Macro To Send Emails with PDF: Multiple Emails and PDF's

LinkBack

Thread Tools

Rate This Thread

Display

Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Re: Macro To Send Emails with PDF: Multiple Emails and PDF's

Thread Information

Users Browsing this Thread

Similar Threads

VBA to send multiple emails does not complete

Problem using a macro to send multiple emails with separate attachments

existing macro to send emails to multiple recipents needs fix

Send outlook emails with message in cells to individual emails associated with them

Sending macro emails using excel: Send emails with their passwords.

Bookmarks

Bookmarks

Posting Permissions