Macro Fun

[evilradish]

I am currently working on a macro that generates 5 reports. These reports are then emailed to a user.

If the report has no data then I want it to not be sent.

Could someone suggest a way of doing this in the macro?

Would appreciate any help or direction as this is my first week @ this job

 

[vbaInet]

Look into the SendObject method. It can be done easily using vba, DoCmd.SendObject. There's info about this in the help files (F1).

Welcome to AWF by the way

 

[evilradish]

Look into the SendObject method. It can be done easily using vba, DoCmd.SendObject. There's info about this in the help files (F1).

Welcome to AWF by the way

Thanks for the tip. After a while of reading managed to fix this. docmd.sendobject worked great - 10 points to you

Just thought I would put some closure on this post

 

[vbaInet]

Glad to hear you got it sorted.