Excelfunction16
New Member
- Joined
- Sep 18, 2016
- Messages
- 3
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.
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.