Email Multiple Attachments From Specified Path

Hi,

I have a macro below that I am using to email a single file to a field of recipients (based on primary, CC, etc. email address fields).

Presently, it's configured to only email a single attachment based on a cell reference (MyFile).
Using this code below (or perhaps it may require an altogether different code/approach), is there a way to configure it to email multiple attachments to the same recipient(s)?

For example, I already tried adding a second variable named "MyFile2" and pointed it to Cells(i,6) where I then specified the file name, but I couldn't get it to work.
Instead of emailing both files (MyFile1 and MyFile2), only MyFile2 was emailed.

Please Login or Register  to view this content.

I would definitely be grateful for some help on this, thanks in advance.

Just add another line with another .attachements.add.

I don't see a reason to open attachment workbooks. Just enter the fullname's for them since you know them.

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx