VBA Help

[Excelfunction16]

Hello good people,


I desperately need your help. I am learning to use vba and have a task I need to complete right away. I've tried solving it myself repeatedly, but am afraid I don't have enough skills or experience to get it done. I really need your help. This is what I am trying to do.


I need to send over 1000 files to various receipients. I have the receipts in an excel spreadsheet in the format below and the recipient contact information is in the worksheet (C:\Users\Shared Drive\Downloads\Statements.xlsx]Transaction Report)


Cells A B C
Account Recipient Email
Row1 B2022 Joe Doe Johndoe@sample.com


2 B1024 Sam Samson samd@sample.com




3 C2020 John Fran Johnfran@sample.com






Files are in a Folder location C:\Users\Shared drive\Downloads


Files


12-31-16 C2020.pdf
01-31-17 B1024.pdf
12-31-16 B2022.Pdf
12-31-16 C2020.xls
01-31-17 B1024.xls
12-31-16 B2022.xls


I want to use vba to determine which files to send to each receipient and I want them to be sent from aparticular em,mmail(e.g.peter@jma.com).


If there is an excel and pdf file for the same account, I want both files (excel and pdf) to be sent.
If only one file (pdf or excel) exists, I want it to send the available file. If no file exists, I want it to ignore that row.


Please note that the file(s) being sent will be based on a particular account of which there are over one thousand receipients.




Thank you so much for all your help.