![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
Please help!
I am new to Outlook VBA developing and need assistance with a project I am on. Here is what I have done so far.. 1. Created a custom task form that I assign and send to a generic mailbox 2. The end user opens the task and fills in data on P.2 page of the custom form and accepts. 3. The task returns to my mailbox with the data filled in. I am trying to access the custom unbound field data to read into MS Access. If anyone can steer me in the right direction It would be greatly appreciated. Thanks in advance, Edro61 |
#2
|
|||
|
|||
![]()
Data in unbound fields won't be transmitted back to your mailbox. It disappears as soon as the item closes.
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "edro61" wrote in message ps.com... Please help! I am new to Outlook VBA developing and need assistance with a project I am on. Here is what I have done so far.. 1. Created a custom task form that I assign and send to a generic mailbox 2. The end user opens the task and fills in data on P.2 page of the custom form and accepts. 3. The task returns to my mailbox with the data filled in. I am trying to access the custom unbound field data to read into MS Access. If anyone can steer me in the right direction It would be greatly appreciated. Thanks in advance, Edro61 |
#3
|
|||
|
|||
![]()
Thank you for the reply Sue.
I have received the task accepted reply with the custom data and you are correct that after I open it it will dissappear. Can it be extracted without opening from outlook? Thanks again edro61 Sue Mosher [MVP-Outlook] wrote: Data in unbound fields won't be transmitted back to your mailbox. It disappears as soon as the item closes. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "edro61" wrote in message ps.com... Please help! I am new to Outlook VBA developing and need assistance with a project I am on. Here is what I have done so far.. 1. Created a custom task form that I assign and send to a generic mailbox 2. The end user opens the task and fills in data on P.2 page of the custom form and accepts. 3. The task returns to my mailbox with the data filled in. I am trying to access the custom unbound field data to read into MS Access. If anyone can steer me in the right direction It would be greatly appreciated. Thanks in advance, Edro61 |
#4
|
|||
|
|||
![]()
You need to use bound controls if you want the user to be able to enter data that Outlook saves with the item.
Data that is in Outlook can be extracted only when Outlook is running. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "edro61" wrote in message oups.com... Thank you for the reply Sue. I have received the task accepted reply with the custom data and you are correct that after I open it it will dissappear. Can it be extracted without opening from outlook? Thanks again edro61 Sue Mosher [MVP-Outlook] wrote: Data in unbound fields won't be transmitted back to your mailbox. It disappears as soon as the item closes. "edro61" wrote in message ps.com... Please help! I am new to Outlook VBA developing and need assistance with a project I am on. Here is what I have done so far.. 1. Created a custom task form that I assign and send to a generic mailbox 2. The end user opens the task and fills in data on P.2 page of the custom form and accepts. 3. The task returns to my mailbox with the data filled in. I am trying to access the custom unbound field data to read into MS Access. If anyone can steer me in the right direction It would be greatly appreciated. Thanks in advance, Edro61 |
#5
|
|||
|
|||
![]()
Sorry! What I meant to say is that when I open the message in the
inbox, The data is there. But when I close the message the it disappears. Should I be extracting from a mailitem or a taskitem? Thanks again Edro61 edro61 wrote: Thank you for the reply Sue. I have received the task accepted reply with the custom data and you are correct that after I open it it will dissappear. Can it be extracted without opening from outlook? Thanks again edro61 Sue Mosher [MVP-Outlook] wrote: Data in unbound fields won't be transmitted back to your mailbox. It disappears as soon as the item closes. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "edro61" wrote in message ps.com... Please help! I am new to Outlook VBA developing and need assistance with a project I am on. Here is what I have done so far.. 1. Created a custom task form that I assign and send to a generic mailbox 2. The end user opens the task and fills in data on P.2 page of the custom form and accepts. 3. The task returns to my mailbox with the data filled in. I am trying to access the custom unbound field data to read into MS Access. If anyone can steer me in the right direction It would be greatly appreciated. Thanks in advance, Edro61 |
#6
|
|||
|
|||
![]()
I honestly don't know. I've never tried to gather data from a task request acceptance. I'd throw Outlook Spy or MFCMAPI at it and see if there's anything there to gather.
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "edro61" wrote in message oups.com... Sorry! What I meant to say is that when I open the message in the inbox, The data is there. But when I close the message the it disappears. Should I be extracting from a mailitem or a taskitem? Thanks again Edro61 edro61 wrote: Thank you for the reply Sue. I have received the task accepted reply with the custom data and you are correct that after I open it it will dissappear. Can it be extracted without opening from outlook? Thanks again edro61 Sue Mosher [MVP-Outlook] wrote: Data in unbound fields won't be transmitted back to your mailbox. It disappears as soon as the item closes. "edro61" wrote in message ps.com... Please help! I am new to Outlook VBA developing and need assistance with a project I am on. Here is what I have done so far.. 1. Created a custom task form that I assign and send to a generic mailbox 2. The end user opens the task and fills in data on P.2 page of the custom form and accepts. 3. The task returns to my mailbox with the data filled in. I am trying to access the custom unbound field data to read into MS Access. If anyone can steer me in the right direction It would be greatly appreciated. Thanks in advance, Edro61 |
#7
|
|||
|
|||
![]()
Thanks again Sue,
Where can I get OutlookSpy? edro61 Sue Mosher [MVP-Outlook] wrote: I honestly don't know. I've never tried to gather data from a task request acceptance. I'd throw Outlook Spy or MFCMAPI at it and see if there's anything there to gather. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "edro61" wrote in message oups.com... Sorry! What I meant to say is that when I open the message in the inbox, The data is there. But when I close the message the it disappears. Should I be extracting from a mailitem or a taskitem? Thanks again Edro61 edro61 wrote: Thank you for the reply Sue. I have received the task accepted reply with the custom data and you are correct that after I open it it will dissappear. Can it be extracted without opening from outlook? Thanks again edro61 Sue Mosher [MVP-Outlook] wrote: Data in unbound fields won't be transmitted back to your mailbox. It disappears as soon as the item closes. "edro61" wrote in message ps.com... Please help! I am new to Outlook VBA developing and need assistance with a project I am on. Here is what I have done so far.. 1. Created a custom task form that I assign and send to a generic mailbox 2. The end user opens the task and fills in data on P.2 page of the custom form and accepts. 3. The task returns to my mailbox with the data filled in. I am trying to access the custom unbound field data to read into MS Access. If anyone can steer me in the right direction It would be greatly appreciated. Thanks in advance, Edro61 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
DTPicker replacement for Due Date control on Custom Task Form | Michelle | Outlook - Using Forms | 0 | May 30th 06 05:22 PM |
Task Message based on custom form goes to Inbox | Don Wilkinson | Outlook - Using Forms | 5 | May 23rd 06 09:22 PM |
How to use custom task form in Web Outlook | DougMunday | Outlook - Using Forms | 1 | April 7th 06 12:18 PM |
Custom Meeting Request Form | ML | Outlook - Using Forms | 5 | February 15th 06 04:23 PM |
Another question about custom Meeting Request form | ML | Outlook - Using Forms | 0 | February 11th 06 04:17 PM |