Sending multiple query's in one attachment (email)

[Guest]

I send three query's (as excel spreadsheets) on a daily basis with the send
object command in a macro. How can I combine these three query's to be sent
in one email, one file, three seperate tabs (or Sheets) within one
spreadsheet?

Thank You.

 

[Rick Wannall]

I used the vb below to transfer 3 queries out to a single spreadsheet. The
spreadsheet did not exist to begin with. The first transfer creates it,
silently. The second two append worksheets, silently. You may want to do
some checking before the transfer so react to the file's existence or
nonexistence before doing the transfer. Depends on how your app is written.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "query2",
"c:\projects\currentdevelopment\TestMultipleQueryExport.xls", True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "query20",
"c:\projects\currentdevelopment\TestMultipleQueryExport.xls", True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "query21",
"c:\projects\currentdevelopment\TestMultipleQueryExport.xls", True

 

[Rick Wannall]

I used the vb below to transfer 3 queries out to a single spreadsheet. The
spreadsheet did not exist to begin with. The first transfer creates it,
silently. The second two append worksheets, silently. You may want to do
some checking before the transfer so react to the file's existence or
nonexistence before doing the transfer. Depends on how your app is written.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "query2",
"c:\projects\currentdevelopment\TestMultipleQueryExport.xls", True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "query20",
"c:\projects\currentdevelopment\TestMultipleQueryExport.xls", True
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "query21",
"c:\projects\currentdevelopment\TestMultipleQueryExport.xls", True

 

[Guest]

Rick, thanks for the response. However, is there anything that I can do
without using code? Not too much of a code person....Can I just use basic
Macro functionality?
Thanks again.

 

[Guest]

Rick, thanks for the response. However, is there anything that I can do
without using code? Not too much of a code person....Can I just use basic
Macro functionality?
Thanks again.

 

[Pieter Wijnen]

Just copy the code into the OnClick Event of a Command Button (Code
Builder)
& Modify the Parameters (Pressing F1 when the text cursor is somewhere
inside "TransferSpreadSheet" will show help)
TransferSpreadsheet can also be used in a macro (All DoCmd *are* macro
actions), but you won't be able to set all possible parameters

HTH

Pieter

"Send Object Command - Two attachments"

 

[Pieter Wijnen]

Just copy the code into the OnClick Event of a Command Button (Code
Builder)
& Modify the Parameters (Pressing F1 when the text cursor is somewhere
inside "TransferSpreadSheet" will show help)
TransferSpreadsheet can also be used in a macro (All DoCmd *are* macro
actions), but you won't be able to set all possible parameters

HTH

Pieter

"Send Object Command - Two attachments"