Does anyone know how to email a pivot table from access, I have a form with a pivot table but when I try to email it the email body is just a regular table. I tryed it in reports where you can put a subform that has the pivot tabel but when i try to eamail it, it says that it cant save subforms.
Im trying to update a old vaule with a new vaule. old=disputed new=1disputed. I have about 30000 records that need this to be changed on. Is there a way to do this without having to create a whole new table?
How do you make a report be the body of an email. I am using the following code to send it as an attachment, but I need it to be the body instead. Also I need the to and cc to generate from a field i have on a form.
Private Sub Command129_Click()
DoCmd.SendObject acSendReport, "Query for...
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.