-
Email attachments without user intervention
VBA noob (apart from editing a few existing macros) so if I'm asking too much, tell me . . .
- I have a series of xlsx files in folder 'refunds'
- Need to produce pdfs of these (single page - UK A4 size)*
- Attach all to email and send at set time (twice a week), ideally with list of attached files.
- Move all files from 'refunds' to 'complete', ideally renamed with a filename prefix/suffix 'refunded (date)'
All without any user intervention at all.
*I may be able to negotiate sending the xlxs without converting to pdf.
Using office 2016 on Windows 10
Last edited by Fyldeboy; 11-17-2021 at 06:13 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules