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!
1  2006  
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 :)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Nicola |
last post by:
Hi Everyone,
I am new to programming and would like to know how to
open an access Report from within vb 6. I am trying to write a program
to organise cross stitch threads. I have found out how...
|
by: Baz'noid |
last post by:
Hi all,
With the recent postal strikes here in the UK i'm trying to persuade access
to email reports at the touch of a button. I've not been able to figure out
how to filter the report - when i...
|
by: Laertes |
last post by:
Hi,
I know there is already a plethora of emails regarding
Groupwise/Access problems but mine is slightly different to the ones
I've read about.
I'm trying to use the sendobject command to...
|
by: chris |
last post by:
I'm looking for some help on setting up a form that will send automated
e-mails through groupwise. I am a novice at codeing and really need a
cut and paste type response. I've had people in the...
|
by: cyranoVR |
last post by:
This is the approach I used to automate printing of Microsoft Access
reports to PDF format i.e. unattended and without annoying "Save As..."
dialogs, and - more importantly - without having to use...
|
by: Salad |
last post by:
Hi: I have the following line:
DoCmd.SendObject acSendReport, "TestReport", _
"SnapshotFormat (*.snp)", _
"joeblow@nowhere.com", , , "Report Test", _
"Does it open correctly?", True
I have...
|
by: F6GGR |
last post by:
Hello,
Here is my problem. I use Access 2000. The data base is simple : one table
(Customers : with Id, Name, etc and e-mail address). Whay I want to realise
: send a e-mail to each customer...
|
by: Klaus Herzberg |
last post by:
Hallo,
with a access-application i send reports via email/SendObject.
After installing office 2007 beta the Sendobject doesn't work. Also
after deinstalling office 2007.
The error: 2046
"the...
|
by: Dan2kx |
last post by:
Hello to all,
i have a new interesting problem to solve....
i have a report that i would like to email to a list of users,
the report is a full page document and is personalised to each user...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
