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