Add dynamic number of attachment in an email sent by macro
I have a macro script for sending out report every day which works fine.
The number of attachment for everyday was fixed. But due to change of data, that number is now changing everyday.
How can I dynamically attach different number of attachments everyday?
I figured out how to generate dynamic number of report.
But when it comes to the email part, the path of attachment is pass to the function as a parameter. I don't know how can I have dynamic number of parameters. Or is there some other way to achieve this?