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

Open Outlook task from Access command button

P: 33
I have a 2007 database that I need to add a command button that will open a new Outlook task and allow the user to input the assignment, start date, due date, etc. I've got plenty of code scripting the info and auto sending the task for other forms, but I can't seem to just open the new task and allow user input. Any advice?
Sep 16 '08 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,628
This code by far would be the simplest approach to opening Outloook, then proceeding to the New Task Window. Substitute your Path to Outlook.exe if necessary:
Expand|Select|Wrap|Line Numbers
  1. Dim varRetVal As Variant
  2. Dim strPathToOutlook As String
  3.  
  4. strPathToOutlook = "C:\Program Files\Microsoft Office\Office\Outlook.exe /c ipm.task"
  5.  
  6. varRetVal = Shell(strPathToOutlook, vbMaximizedFocus)
Sep 19 '08 #2

Post your reply

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