Add multiple tables to send an attachment through out look

[kata_vijay]

Hi, for below code i need to add one more table query to attach two excel files in one attachment without exporting into file and take those files as attachment. when i click button i need two excel files should attach in an email

for below query i have added only one query attachment I.e,. qryRouting_Changese i need to add one more example: qAgentRouting_Final into below query.. Please help

DoCmd.SendObject acSendQuery, qryRouting_Changes, acFormatXLS, _
To:="SDM", _
CC:="DBascar;nyadav2;raariga;vkata", _
Subject:="Account Routing changes", _


MessageText:="Hi All" & vbCrLf & vbCrLf & _
"Attached file for previous day Account Routing changes " & vbCrLf & vbCrLf & _
"Thanks," & vbCrLf & "Vijay" & vbCrLf & "Sr.Analyst, IO - Global Reference Data " & vbCrLf & "Ext (8132483) " & vbCrLf & vbCrLf & _
"This electronic communication, including all attachments, contains confidential information that is intended only for the person to which it is addressed. Any review, re-transmission, dissemination, disclosure or other use of this information, either in whole or in part, by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, or are not the intended recipient, please do not open or view any attachments, read, act upon, discuss, print, disclose, copy, retain or redistribute any portion of this electronic communication. Please notify the sender immediately and delete all copies of the message and attachments from any computer or electronic storage device."

[ranman256]

either sent 3 emails , 1 attachment each
DoCmd.SendObject acSendQuery, query

or send 1 email w 3 attachments by exporting to a file.
docmd.transferspreadsheet
it don't cost nuthin to export a spreadsheet then attach it. https://www.accessforums.net/showthr...ght=send+email

These are 2 different animals, you cant add your own method if they don't allow it.

[kata_vijay]

but iam facing a problem when i am export and attach the files, some times the export files are not able to replace the old file