473,805 Members | 2,297 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 4146
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
1775
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 know the problem is in the OnStartupComplete function. If I comment this function out, Outlook closes properly. I have added a GC.Collect at the end, but that doesn't work either. I don't thing the "oCommandBars = Nothing" is actually getting...
1
1858
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 at all, hope u guys can gimme a hand , heres the code, Public Sub OnStartupComplete(ByRef custom As System.Array) Implements Extensibility.IDTExtensibility2.OnStartupComplete
1
8582
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 you do a Ctrl Alt Del, and see them all sitting there in the task manager.
3
5817
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 installed on something other than the "C" drive. So can anyone advise me how to open Outlook by using a relative path rather than the code I am using here.
3
3415
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. --------------------- OutLook._Application outlookObj = new OutLook.Application();
3
3995
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 appropriate record. I have searched through many Outlook and Access books and the web and cannot seem to find any info on this. Your help would be greatly appreciated. Serge
0
1336
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 a PDF file saved on a web server. Right now, I have to run the task manually, but wonder whether I can somehow automate this using VB to run the task automatically at a predetermined time (e.g., daily at 12:00 a.m.) Your advice or links to...
0
1270
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 a PDF file saved on a web server. Right now, I have to run the task manually, but wonder whether I can somehow automate this using VB to run the task automatically at a predetermined time (e.g., daily at 12:00 a.m.) Your advice or links to...
3
4452
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) and Access 2000 (9.0.2720) with the following References selected: Visual Basic for Applications MS Access 9.0 Object Library MS DAO 3.6 Object Library
0
10617
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10370
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9186
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7649
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6876
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5545
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4328
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 we have to send another system
2
3849
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3008
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.