X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Report Export Or Query Export To Excel Format, Access 2007    
post Oct 26 2017, 07:35 PM

Posts: 50
Joined: 23-April 16

I was trying to email a report but I cannot get the email part to work.
The Database opens and generate and export a report to outlook or desktop.
My question is from a database in the server can I export to multiple desktops in the same local network?
Each laptop have exclusive names and all are mapped to the network server

Go to the top of the page
post Oct 27 2017, 12:40 PM

Posts: 849
Joined: 25-April 14

you can email sheets using:
docmd.SendObject acSendQuery ,"qsMyQuery",acFormatXLS,sTo,,,sSubj,sBody
docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo,,,sSubj,sBody

or export the query to a file (on their share) using:
docmd.TransferSpreadsheet acExport ,acSpreadsheetTypeExcel12,vQry,vFile,true,vSheetName
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    23rd March 2018 - 11:55 AM