Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


emailing a report from Microsoft Access

 
Logged in as: Guest
arrSession:exec spGetSession 2,2,49495
 Active Users: There are 0 members and 0 guests.
 Users viewing this topic: none
 

 

 
  
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> emailing a report from Microsoft Access
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!
Page: [1]
Login
Message << Older Topic   Newer Topic >>
 emailing a report from Microsoft Access - 7/13/2007 9:21:39 AM   
  cwevenson

 

Posts: 4
Score: 0
Joined: 5/24/2007
Status: offline
I have a request from one of my users to figure out how to email a access report at the end of every month for them. i figure i would just call a VBscript in schedualer but am a bit stumped on how to proceed with the script. I can open access, but it keeps asking me to confirm opening. So I have to figure out how to force the open in the background and have it call up a predeveloped report based on a query and then email that report to a recipient that I can hard code in the script.

Any idea how I might start with this?
 
 
Post #: 1
 
 
 
  

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> emailing a report from Microsoft Access Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts