you can use the docmd.sendobject
you do not need to include any attachment and you can customize the messsage,subject recipients and so forth
accesss help will show you what to use for each parameter
One of the options is to have the message show on the screen or you can set it to send...
is the formula that needs to be changed located in the same cell on each worksheet? If so, use group mode to change all the sheets within each workbook at one time. are you familiar with group mode?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.