Hi there - Using MS Access 2007.
I have a FORM with a macro that runs a query to generate ONE excel file and attaches to email using MS Out look to send out. - That Works great.
Problem: Multiple users to send email & attachment.
I would like for the macro to generate excel file (S) - based by the UID.
Can someone suggest a better way of handling this that is not time consuming?
Thanks In advance!
I have a FORM with a macro that runs a query to generate ONE excel file and attaches to email using MS Out look to send out. - That Works great.
Problem: Multiple users to send email & attachment.
I would like for the macro to generate excel file (S) - based by the UID.
Can someone suggest a better way of handling this that is not time consuming?
Thanks In advance!