Email 2 different reports in one email

[SteveE]

I have two reports which are run via a macro one produces a .snp file the other an excel file (both of the same data based the same query).
I use the send object to send these files as attachments to several people. This produces two emails with one attachment in each. My question is how can I produce one email with both attachments in it? Any help or advise appreciated.

Steve

 

[Hayley Baxter]

Have a look at the link below

Link