Search results for query: *

In the case that im not here some one else will have to run the report and send the eamail. Rather then have to train someone on how to do this it would be better to just have them click a button and everything be automated for them.

i tryed that but the macro shows up blank

Ok i set all microsoft office refference to get this to work, but it sends the whole workbook, all i want it to do is send the pivot table as the body.

i get run time error 91 "object variable or with block variable not set

I got this much so far from doing hours of searching, but now i get a error saying to set object varible. Private Sub Command13_Click() DoCmd.OpenForm "qds actions taken", acFormPivotTable, , , acFormPropertySettings, acWindowNormal DoCmd.RunCommand acCmdPivotTableExportToExcel...

I have been to lots have excel and access sites for help on this. I can get it to transfer the data to a spread sheet but i can seem to find the code to export the actual pivot to a temp excel sheet and then have it email the pivot.

I have thought about that, but what would be the code to have access spit it out to excel and then email it with set email addresss all from one button in access?

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.

I am new at access. I need a pivot table that automaticly looks at Sat-Fri of last weeks data any time you open it.

Im kinda new at this, How would the update query be set up? I also so some things about a replace function but now sure how to make it work.

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?

Thinks I put the following code in and now it works. Also as a bonus if you cancle the email i dont get the error that says you have cancled and lock access up any more. Private Sub Command129_Click() Const ForReading = 1, ForWriting = 2, ForAppending = 3 Dim fs, f Dim RTFBody, strTo Dim...

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...