I am using the following code which is working OK and sends my report into OUtlook....
DoCmd.SendObject acSendReport, "Rpt_FPM report", acFormatRTF, ASMEmail.Value, , , "FPM Report", "Please find FPM reports attached", -1
I would really like to attach 2 reports to the same email - is that possible, I tried the code below but it does not work.
DoCmd.SendObject acSendReport, "Rpt_FPM report" & "Rpt_ASMReport", acFormatRTF, ASMEmail.Value, , , "FPM Report", "Please find FPM reports attached", -1
Any help would be appreciated.
Ta
DoCmd.SendObject acSendReport, "Rpt_FPM report", acFormatRTF, ASMEmail.Value, , , "FPM Report", "Please find FPM reports attached", -1
I would really like to attach 2 reports to the same email - is that possible, I tried the code below but it does not work.
DoCmd.SendObject acSendReport, "Rpt_FPM report" & "Rpt_ASMReport", acFormatRTF, ASMEmail.Value, , , "FPM Report", "Please find FPM reports attached", -1
Any help would be appreciated.
Ta