473,513 Members | 2,323 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Open Outlook task from Access command button

33 New Member
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
1 4120
ADezii
8,834 Recognized Expert Expert
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

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

Similar topics

4
1763
by: damian | last post by:
Help! I created a COM addin using vb.net based on the KB article 302896 (http://support.microsoft.com/default.aspx?scid=kb;en-us;302896). The problem is Outlook remains in memory when after it. I...
1
1848
by: Himselff | last post by:
Hi guys, Im developing a lil add-in that is goiing to allow the user by a button click to auto print PDF doc which are attach to hes emails, i think the things is to simple cause its not working...
1
8559
by: bobdydd | last post by:
Hi Everybody Windows XP, Access 2000, Outlook 2000 I am looking for a way to Close All Instances of Microsoft Outlook, with VBA. Both the "Seen One" and the unseen ones that you see when...
3
5786
by: bobdydd | last post by:
Hi Everybody Access 2000, Outlook 2000 Windows XP I am running the code below to open Microsoft Outlook from a Command Button. It works fine until I tried it on a machine that has Office...
3
3401
by: mwolowski | last post by:
Hello, I'd like to add tasks, appointments, etc using c# to outlook For example i added reference using OutLook = Microsoft.Office.Interop.Outlook; and the code: 1. ---------------------...
3
3982
by: getro | last post by:
Hi Everyone, I need to open an Access 2003 form to a specific record from a custom Outlook 2003 Appointment form. The form has a command button that would pass a record id to access and open the...
0
1320
by: jmartmem | last post by:
Greetings, I have an Outlook 2007 task that I saved from an Access 2007 database. Specifically, the task contains a "Run Export" command button in the Access group to export an Access report into...
0
1251
by: jmartmem | last post by:
Greetings, I have an Outlook 2007 task that I saved from an Access 2007 database. Specifically, the task contains a "Run Export" command button in the Access group to export an Access report into...
3
4411
by: Frisco Depot | last post by:
I have a Run-time error problem on a Vista computer. There are two computers involved, The first one is Vista Home Premium SP1 with Windows Mail Version 6.0.6000.16386 (vista_rtm.061101-2205)...
0
7267
marktang
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,...
0
7175
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...
0
7391
Oralloy
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,...
0
7553
jinu1996
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...
1
7120
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7542
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
3235
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1609
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
466
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.