Extract to and cc from generated e-mail message 
Author Message
 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  
 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  
 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  
 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  
 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  
 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  
 
 [ 6 post ] 

 Relevant Pages 

1. need help on formatting a message sent to cc: mail from VB

2. VIM: Messaging With cc:Mail

3. How to CC mail messages ?

4. Code to extract a formatted message body of an email into an access Database

5. Need a program to extract email addresses from MS Outlook 2000 folders/messages

6. Macro to extract sender's address from email message

7. Extract cell contents and import into an automated Outlook email message

8. Extracting attachements that are mail messages

9. Extracting attachements that are mail messages

10. Generating Email messages from VB5

11. copying details from Outlook form to a VBS generated mail message

12. generating a mail message with screen shot of emulation

 

 
Powered by phpBB® Forum Software