G
George Liu
I have a little problem that I’m not sure on how to approach it:
I am trying to send a Report generated by MS Access via email through the
command SendObject.
DoCmd.SendObject acSendReport, "Practitioners2", acFormatXLS, _
"George Liu; [email protected]", "George Liu", , _
"SubjectLine", , False
I’m not sure exactly how to structure the whole VBA code to access the
database, and searching around, there aren’t a complete code.
I’m not even sure what the _ does in the code above.
Anyway, I have a example database with Doctors and Patients.
The report generates a list of the patients the doctor has seen and I want
to send it off to their emails in Excel format
I’m currently stuck on how to send it to one Doctor, and I will then need to
send it to multiple doctors with multiple (different) Reports.
Your help would be greatly appreciated.
Thanks in advanced!
I am trying to send a Report generated by MS Access via email through the
command SendObject.
DoCmd.SendObject acSendReport, "Practitioners2", acFormatXLS, _
"George Liu; [email protected]", "George Liu", , _
"SubjectLine", , False
I’m not sure exactly how to structure the whole VBA code to access the
database, and searching around, there aren’t a complete code.
I’m not even sure what the _ does in the code above.
Anyway, I have a example database with Doctors and Patients.
The report generates a list of the patients the doctor has seen and I want
to send it off to their emails in Excel format
I’m currently stuck on how to send it to one Doctor, and I will then need to
send it to multiple doctors with multiple (different) Reports.
Your help would be greatly appreciated.
Thanks in advanced!