I've been tasked to find a better way to accomplish a task on of our admins has been doing. Currently, one of our admins is taking a stack of invoices, scanning them in as PDF, and renaming them by the persons names (these are expense reimbursement invoices). I'm not really sure how we would automate this. Here is the part I think we can automate - she is then saving each file as Doe, John 04.2012.pdf then attaching each individually to an email, and sending them all out separately. Is there a way to do this automatically? I wasn't sure how to start the VBA since it's not in excel. Would you write in outlook? The email address of each that it needs to be sent to is this format jdoe@sample.com. I think the macro can just read the name as she saves these files to accomplish this. She usually adds a body to the email, with two fields that need to be updated (ie We have deducted from your next check due "Date1". Please email me by "Date2" if you have any questions.) The two dates would be the same for all emails in a batch, so we would just need to update these once. Other information - the documents are sitting on her C drive (C:\Documents and Settings\User1\Desktop\Employees). Anyone know how I could accomplish automating this? Any insight is appreciated! Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro to email PDF documents off my desktop automatically
- Thread starter mamcelro
- Start date
Similar threads
- Question
- Question
