I have created a button to send email to person. It attached my query in excel format it is working fine. No issue. But I want to send multiple file in one shot , it is possible .
I have created a macro but there is not macro object can be sent.
here I found msdn website
acSendForm
2
Send a Form.
acSendModule
5
Send a Module.
acSendNoObject
-1
(Default) Don't send a database object.
acSendQuery
1
Send a Query.
acSendReport
3
Send a Report.
acSendTable
Send a Table.
Is it possible to attached 3 different file in one shot ?
Pls advise.