Search results
-
R
emailing from within access
Acorpolis, I was looking for a more automated option. I did manage to call one procedure from the other. So it works, but not very elegant. thanks- rneaul
- Post #3
- Forum: Modules & VBA
-
R
create a macro to export to an excel file using the current date as a name
The format error was the () after the word Date... should just read Format(Date, "yyyymmdd") -
R
emailing from within access
All, I am trying to automate the process of sending a query result via email. I have code that will export a query as an excel document, using DoCmd.SendObject, but it has the name of the query. DoCmd.SendObject acSendQuery, "Dailyrpt", acFormatXLSX, email.address, , , "Daily Report", "This...- rneaul
- Thread
- Replies: 4
- Forum: Modules & VBA
-
R
create a macro to export to an excel file using the current date as a name
I attempted to use the above modified as: Private Sub Command42_Click() DoCmd.OutputTo acOutputQuery,"complete",acFormatXLS,"C:\Users\roland.neault\My Documents\PSA complete" & Format(Date(),yyyymmdd") & ".xls" Exit_Command42_Click: End Sub But I get a syntax error... can you point out where...