Extract to and cc from generated e-mail message
Author |
Message |
Neo [MVP - Outlook #1 / 6
|
 Extract to and cc from generated e-mail message
You would want to review the "Recipients" collection of the item being sent to get the names (possible email addresses). The problem with this though however is that you might have to change the way you send email. For example, if docmd.sendobject sends the message right way, you would have to use the automation object exposed by Outlook to acquire the item from the sent items folder and then review the collection.* * Since Outlook 98's object model doesn't let you captured the send event from VBA, you are going to have to write a custom form that captures the Item_Send event to accomplish what you want and pass that information back to you an activex dll.
I have written an activeX.dll that uses automation to Outlook98 to send formatted e-mail messages. This dll is used by a database written in Access 97 (docmd.sendobject sends straight text only). My problem is that I do have a pre-defined set of recipients for users, and when they want to send messages, the to and cc fields are automatically populated from the database. However, sometimes, other addresses are manually added by the user(s), or the default ones are changed, etc., and this needs to be recorded in the database. How can I get the values from the to and cc fields of the message when the user clicks on the 'send' button? thanks Faizal
|
Sun, 30 Mar 2003 03:00:00 GMT |
|
 |
Faizal Di #2 / 6
|
 Extract to and cc from generated e-mail message
I have written an activeX.dll that uses automation to Outlook98 to send formatted e-mail messages. This dll is used by a database written in Access 97 (docmd.sendobject sends straight text only). My problem is that I do have a pre-defined set of recipients for users, and when they want to send messages, the to and cc fields are automatically populated from the database. However, sometimes, other addresses are manually added by the user(s), or the default ones are changed, etc., and this needs to be recorded in the database. How can I get the values from the to and cc fields of the message when the user clicks on the 'send' button? thanks Faizal
|
Mon, 31 Mar 2003 04:54:33 GMT |
|
 |
Faizal Di #3 / 6
|
 Extract to and cc from generated e-mail message
Thanks for that, Neo. I did think of that, but I was hoping for a simpler solution. I noticed that there was a send event in the outlook component in object explorer - I was hoping I could make use of that somehow. I guess I could try your suggestion except that some users might have a long list on messages in their sent items folder ... Faizal
Quote: > You would want to review the "Recipients" collection of the item being sent > to get the names (possible email addresses). The problem with this though > however is that you might have to change the way you send email. For > example, if docmd.sendobject sends the message right way, you would have to > use the automation object exposed by Outlook to acquire the item from the > sent items folder and then review the collection.* > * Since Outlook 98's object model doesn't let you captured the send event > from VBA, you are going to have to write a custom form that captures the > Item_Send event to accomplish what you want and pass that information back > to you an activex dll.
> I have written an activeX.dll that uses automation to Outlook98 to send > formatted e-mail messages. This dll is used by a database written in Access > 97 (docmd.sendobject sends straight text only). > My problem is that I do have a pre-defined set of recipients for users, and > when they want to send messages, the to and cc fields are automatically > populated from the database. > However, sometimes, other addresses are manually added by the user(s), or > the default ones are > changed, etc., and this needs to be recorded in the database. > How can I get the values from the to and cc fields of the message when the > user clicks on the 'send' button? > thanks > Faizal
|
Mon, 31 Mar 2003 12:07:25 GMT |
|
 |
Neo #4 / 6
|
 Extract to and cc from generated e-mail message
Unfortunately, Outlook 98 does not expose events to external applications like VB, VBA, Delphi, C++, .etc. The best you could do with your idea is create a custom Outlook form that captures the Item_Send event or develop an Exchange extension.
Quote: > Thanks for that, Neo. > I did think of that, but I was hoping for a simpler solution. I noticed that > there was a send event in the outlook component in object explorer - I was > hoping I could make use of that somehow. > I guess I could try your suggestion except that some users might have a long > list on messages in their sent items folder ... > Faizal
> > You would want to review the "Recipients" collection of the item being > sent > > to get the names (possible email addresses). The problem with this though > > however is that you might have to change the way you send email. For > > example, if docmd.sendobject sends the message right way, you would have > to > > use the automation object exposed by Outlook to acquire the item from the > > sent items folder and then review the collection.* > > * Since Outlook 98's object model doesn't let you captured the send event > > from VBA, you are going to have to write a custom form that captures the > > Item_Send event to accomplish what you want and pass that information back > > to you an activex dll.
> > I have written an activeX.dll that uses automation to Outlook98 to send > > formatted e-mail messages. This dll is used by a database written in > Access > > 97 (docmd.sendobject sends straight text only). > > My problem is that I do have a pre-defined set of recipients for users, > and > > when they want to send messages, the to and cc fields are automatically > > populated from the database. > > However, sometimes, other addresses are manually added by the user(s), or > > the default ones are > > changed, etc., and this needs to be recorded in the database. > > How can I get the values from the to and cc fields of the message when the > > user clicks on the 'send' button? > > thanks > > Faizal
|
Fri, 04 Apr 2003 03:00:00 GMT |
|
 |
Faizal Di #5 / 6
|
 Extract to and cc from generated e-mail message
Hi Neo I wouldn't like to create custom forms, because I presume that I would have to then configure each of the clients with that form (I may be wrong). I am, however, interested in developing an Exchange extension. The only problem is I don't know what it is! nor how to develop it! and will it allow me to send formatted e-mail messages? Got any hints? thanks Faizal
Quote: > Unfortunately, Outlook 98 does not expose events to external applications > like VB, VBA, Delphi, C++, .etc. The best you could do with your idea is > create a custom Outlook form that captures the Item_Send event or develop an > Exchange extension.
> > Thanks for that, Neo. > > I did think of that, but I was hoping for a simpler solution. I noticed > that > > there was a send event in the outlook component in object explorer - I was > > hoping I could make use of that somehow. > > I guess I could try your suggestion except that some users might have a > long > > list on messages in their sent items folder ... > > Faizal
> > > You would want to review the "Recipients" collection of the item being > > sent > > > to get the names (possible email addresses). The problem with this > though > > > however is that you might have to change the way you send email. For > > > example, if docmd.sendobject sends the message right way, you would have > > to > > > use the automation object exposed by Outlook to acquire the item from > the > > > sent items folder and then review the collection.* > > > * Since Outlook 98's object model doesn't let you captured the send > event > > > from VBA, you are going to have to write a custom form that captures the > > > Item_Send event to accomplish what you want and pass that information > back > > > to you an activex dll.
> > > I have written an activeX.dll that uses automation to Outlook98 to send > > > formatted e-mail messages. This dll is used by a database written in > > Access > > > 97 (docmd.sendobject sends straight text only). > > > My problem is that I do have a pre-defined set of recipients for users, > > and > > > when they want to send messages, the to and cc fields are automatically > > > populated from the database. > > > However, sometimes, other addresses are manually added by the user(s), > or > > > the default ones are > > > changed, etc., and this needs to be recorded in the database. > > > How can I get the values from the to and cc fields of the message when > the > > > user clicks on the 'send' button? > > > thanks > > > Faizal
|
Tue, 08 Apr 2003 04:20:41 GMT |
|
 |
Neo [MVP - Outlook #6 / 6
|
 Extract to and cc from generated e-mail message
Try starting with http://msdn.microsoft.com/library/psdk/exchcli/_mapi1book_how_extensi... k.htm on learning how to develop Exchange Extensions. Also, since this interface involves the use of Extended MAPI, you will be able to send out rich content.
Hi Neo I wouldn't like to create custom forms, because I presume that I would have to then configure each of the clients with that form (I may be wrong). I am, however, interested in developing an Exchange extension. The only problem is I don't know what it is! nor how to develop it! and will it allow me to send formatted e-mail messages? Got any hints? thanks Faizal
Quote: > Unfortunately, Outlook 98 does not expose events to external applications > like VB, VBA, Delphi, C++, .etc. The best you could do with your idea is > create a custom Outlook form that captures the Item_Send event or develop an > Exchange extension.
> > Thanks for that, Neo. > > I did think of that, but I was hoping for a simpler solution. I noticed > that > > there was a send event in the outlook component in object explorer - I was > > hoping I could make use of that somehow. > > I guess I could try your suggestion except that some users might have a > long > > list on messages in their sent items folder ... > > Faizal
> > > You would want to review the "Recipients" collection of the item being > > sent > > > to get the names (possible email addresses). The problem with this > though > > > however is that you might have to change the way you send email. For > > > example, if docmd.sendobject sends the message right way, you would have > > to > > > use the automation object exposed by Outlook to acquire the item from > the > > > sent items folder and then review the collection.* > > > * Since Outlook 98's object model doesn't let you captured the send > event > > > from VBA, you are going to have to write a custom form that captures the > > > Item_Send event to accomplish what you want and pass that information > back > > > to you an activex dll.
> > > I have written an activeX.dll that uses automation to Outlook98 to send > > > formatted e-mail messages. This dll is used by a database written in > > Access > > > 97 (docmd.sendobject sends straight text only). > > > My problem is that I do have a pre-defined set of recipients for users, > > and > > > when they want to send messages, the to and cc fields are automatically > > > populated from the database. > > > However, sometimes, other addresses are manually added by the user(s), > or > > > the default ones are > > > changed, etc., and this needs to be recorded in the database. > > > How can I get the values from the to and cc fields of the message when > the > > > user clicks on the 'send' button? > > > thanks > > > Faizal
|
Wed, 09 Apr 2003 03:00:00 GMT |
|
|
|