Here is some VB code I converted from a macro. Runs great, but the Outlook security settings are not allowing me to automatically send the report.
Option Compare Database
Function zmacDialysis_Mail_TEST()
On Error GoTo zmacDialysis_Mail_TEST_Err
If (DCount(1, "qryDialysis") > 0) Then
DoCmd.SendObject acReport, "rptDialysis", "PDFFormat(*.pdf)", "email
address(s)", "", "", "DACR - Dialysis", "Here are the daily ancillary charges
for the Effective Date. Please review and verify these charges. Then
sign/date the Reconciliation Form and return.", False, ""
End If
zmacDialysis_Mail_TEST_Exit:
Exit Function
zmacDialysis_Mail_TEST_Err:
MsgBox Error$
Resume zmacDialysis_Mail_TEST_Exit
End Function
Thanks,
Chase Rodgers
Financial Reporting Manager
[cid:[email protected]]
*214-473-7490
*[email protected]<mailto:[email protected]>
From: [email protected] [mailto:[email protected]]
Sent: Thursday, November 19, 2009 10:01 AM
To: [email protected]
Subject: [talkbws] RE: Running an Access report
Greetings,
So what's the going rate for my magic these days :)
Would need a bit more info on what's needed here.
I take it these are prebuilt <things> in an Access file? That can be executed,
creates an output and the outputs get emailed?
I don't do a lot with Access - but if you can give me the "official Access
name" for whatever it is you need run, that'd help.
Regards,
Thom
Thom C. Blackwell
Product Manager
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com<http://www.bossoft.com/>
Sign up for my weekly
webinar!<http://www.bostonworkstation.com/customer_center/special_events.aspx>
LEGAL NOTICE Unless expressly stated otherwise, this message is confidential
and may be privileged. It is intended for the addressee(s) only. Access to this
E-mail by anyone else is unauthorized. If you are not an addressee, any
disclosure or copying of the contents of this E-mail or any action taken (or
not taken) in reliance on it is unauthorized and may be unlawful. If you are
not an addressee, please inform the sender immediately, then delete this
message and empty from your trash.
From: [email protected] [mailto:[email protected]]
Sent: Thursday, November 19, 2009 10:57 AM
To: Talk
Subject: [talkbws] RE: Running an Access report
Yep, that is exactly what I need to do... with about 70 different employees.
Work your magic THOM?
Thanks,
Reese
Reese E. Walker
Lead Financial Systems Analyst
Manager, Phoebe Cares Dept.
Phoebe Putney Memorial Hospital
Phone: (229) 312-4259
"Excellence is not a skill. It's an attitude." ~ Ralph Marston
________________________________
From: [email protected] [mailto:[email protected]]
Sent: Thursday, November 19, 2009 10:53 AM
To: [email protected]
Subject: [talkbws] RE: Running an Access report
Great question.
I would also like to automate sending reports from access via email via Boston
Workstation (without the security warnings).
Some code or hints on how to work around that would be a tremendous help in
streamlining some of our reports.
Thanks,
Chase Rodgers
Financial Reporting Manager
The Medical Center of Plano
From: [email protected] [mailto:[email protected]]
Sent: Thursday, November 19, 2009 08:36 AM
To: [email protected]
Subject: [talkbws] Running an Access report
Is it possible to program BWS to log into access and run certain reports from a
selection menu?
Reese
Reese E. Walker
Lead Financial Systems Analyst
Manager, Phoebe Cares Dept.
Phoebe Putney Memorial Hospital
Albany, GA. 31702
Phone: (229) 312-4259
Pager: (229) 431-7658
Fax: (229) 312-4316
"Excellence is not a skill. It's an attitude." ~ Ralph Marston
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
________________________________
Disclaimer:
The HIPAA Final Privacy Rule requires covered entities to safeguard
certain Protected Health Information (PHI) related to a person's
healthcare. Information being faxed to you may include PHI after
appropriate authorization from the patient or under circumstances
that do not require patient authorization. You, the recipient, are
obligated to maintain PHI in a safe and secure manner. You may not
re-disclose without additional patient consent or as required by
law. Unauthorized re-disclosure or failure to safeguard PHI could
subject you to penalties described in federal (HIPAA) and state
law. If you the reader of this message are not the intended
recipient, or the employee or agent responsible to deliver it to
the intended recipient, please notify us immediately and destroy
the related message.
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
<<inline: image002.jpg>>
