|
| 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
March 31st 07, 06:54 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Form linked to Excel
I need to track my e-mails by job# and then number each e-mail consecutively
as they are being sent out. I'm using Outlook 2003. The route I'm taking is to create a form similar to the 'send e-mail' template from Outlook, add a combo for job#s and link it to an Excel sheet. Is this the best route to go? How can I link it to an Excel file? Thanks in advance. 
|
| Ads |
|
#2
April 3rd 07, 01:47 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Form linked to Excel
You would have to write code behind the custom form to perform any such linking. However, using a custom form for messages to external recipients generally is a bad idea, because it can cause problems with attachments. A better approach might be to use VBA code in the Application_ItemSend event handler to set the built-in BillingInformation or Mileage property.
-- 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 "Myriam" wrote in message ... I need to track my e-mails by job# and then number each e-mail consecutively as they are being sent out. I'm using Outlook 2003. The route I'm taking is to create a form similar to the 'send e-mail' template from Outlook, add a combo for job#s and link it to an Excel sheet. Is this the best route to go? How can I link it to an Excel file? Thanks in advance.
|
|
#3
April 3rd 07, 05:20 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Form linked to Excel
Thanks for your response.
I need to study those properties, I'm not familiar with them. (By the way, I just bought 2 of your books--very good!) Thanks again. Regards, "Sue Mosher [MVP-Outlook]" wrote: You would have to write code behind the custom form to perform any such linking. However, using a custom form for messages to external recipients generally is a bad idea, because it can cause problems with attachments. A better approach might be to use VBA code in the Application_ItemSend event handler to set the built-in BillingInformation or Mileage property. -- 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 "Myriam" wrote in message ... I need to track my e-mails by job# and then number each e-mail consecutively as they are being sent out. I'm using Outlook 2003. The route I'm taking is to create a form similar to the 'send e-mail' template from Outlook, add a combo for job#s and link it to an Excel sheet. Is this the best route to go? How can I link it to an Excel file? Thanks in advance.
|
|
#4
April 3rd 07, 07:49 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Form linked to Excel
They're just text properties that you can use for whatever purpose you want.
You can get the books' code samples from the links in my signature. -- 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 "Myriam" wrote in message ... Thanks for your response. I need to study those properties, I'm not familiar with them. (By the way, I just bought 2 of your books--very good!) Thanks again. Regards, "Sue Mosher [MVP-Outlook]" wrote: You would have to write code behind the custom form to perform any such linking. However, using a custom form for messages to external recipients generally is a bad idea, because it can cause problems with attachments. A better approach might be to use VBA code in the Application_ItemSend event handler to set the built-in BillingInformation or Mileage property. "Myriam" wrote in message ... I need to track my e-mails by job# and then number each e-mail consecutively as they are being sent out. I'm using Outlook 2003. The route I'm taking is to create a form similar to the 'send e-mail' template from Outlook, add a combo for job#s and link it to an Excel sheet. Is this the best route to go? How can I link it to an Excel file? Thanks in advance.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Export Custom Task Form Data to Excel | [email protected] | Outlook - General Queries | 0 | March 21st 07 11:50 PM |
| Eporting from a form to Excel | Graham Y | Outlook - Using Forms | 1 | November 22nd 06 02:50 PM |
| How do I Autopopulate an Outlook form from an Excel Sheet? | AttyBhai | Outlook - Using Forms | 1 | September 19th 06 02:18 PM |
| Showing Linked Contact on Appointment Form | JohnCarverInOz | Outlook - Calandaring | 3 | June 16th 06 12:25 AM |
| Outlook program, outlook form, local webpage form & Excel | Junoon | Outlook and VBA | 1 | April 3rd 06 07:45 AM |
Linear Mode
