MacroNobie
New Member
- Joined
- Mar 29, 2018
- Messages
- 12
Hi everybody,
I'm looking for a code, where I can specify who to send an email to and choose an attachment for it.
I have to send every month 20 excel files to the same 20 recipients but always different excel files for the ongoing month. That is why I would like to create a button for each recipient, click on it and then choose the new excel file in the specific folder and send it.
I hope you guys can help me
Best regards
I'm looking for a code, where I can specify who to send an email to and choose an attachment for it.
I have to send every month 20 excel files to the same 20 recipients but always different excel files for the ongoing month. That is why I would like to create a button for each recipient, click on it and then choose the new excel file in the specific folder and send it.
I hope you guys can help me
Best regards