By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,978 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,978 IT Pros & Developers. It's quick & easy.

MS Access - Reports/SendObject Help

P: 2
I have a little VBA/Access - Reports problem and I知 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; neo_skool@hotmail.com", "George Liu", , _
"SubjectLine", , False

I知 not sure exactly how to structure the whole VBA code to access the database, and searching around, there aren稚 a complete code.

I知 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知 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!
Dec 11 '07 #1
Share this Question
Share on Google+
1 Reply


Jim Doherty
Expert 100+
P: 897
I have a little VBA/Access - Reports problem and I知 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; neo_skool@hotmail.com", "George Liu", , _
"SubjectLine", , False

I知 not sure exactly how to structure the whole VBA code to access the database, and searching around, there aren稚 a complete code.

I知 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知 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!

The last bit of your post refers to ultimately sending to multiple doctors and multiple reports. The DoCmd.Sendobject method will not service your needs for this overall as it will not give you sufficient control over your program flow you will have to look at office 'automation' methods there are plenty of examples on here of how to do it if you search on here.

If you get stuck get back to me :)

Regards

Jim :)
Dec 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.