create an e-mail mailing from a folder containing tasks items 
Author Message
 create an e-mail mailing from a folder containing tasks items

Hello All,

can someone provide me with a code (or multiple code samples) to do this
? :

I have Task folder, containing a certain amount of IPM.Task. items (in
customized forms)...

Each IPM.Task.item that is created is ALWAYS linked with a contact
(which is located on an Exchange server in a folder containing
IPM.Contacts items).

One of the custom field of this IPM.Task.form contains the contact's
e-mail
(I managed to display this e-mail directly in the task form using a
little VBS script)

So... I'd like to know how to program a VBA macro, which would "catch"
(doing a sort of request, or filtering, or whatever....) all the emails
linked to each task, and generate in a list format, or  a comma
separated string, for exemple...,

...or, much better, open a blank e-mail, and "paste" all these e-mail
addresses in the "to" or "copy" field !

Thank you for your time, and your detailled help... as I'm a beginner...

Very Best Regards,

H

--
=======================================================
Current digital authentication ID:****8416200011122****
-------------------------------------------------------

9, rue Marcel Monge         / Home: +33(0)1 47 28 83 78
F-92150 - Suresnes          / Mob:  +33(0)6 62 77 33 85
Paris - France              / Work: +33(0)1 41 90 65 04
=======================================================



Fri, 30 May 2003 22:57:14 GMT  
 create an e-mail mailing from a folder containing tasks items
If I understand what you're trying to do, this might be the pseudo code for
creating a message to the contact(s) linked to a particular task:

Create a new message and get its Recipients collection
Loop through the task's Links collection
    Get the ContactItem associated with a link
    Get the contact's first address
    Add the address to the Recipients collection
    Repeat for other addresses
Continue with the next Link

But if you already have the e-mail address in a custom form, you can just
add that to Recipients, rather than looping through Links.
--
Sue Mosher, Outlook MVP
Author of
     Teach Yourself Microsoft Outlook 2000 Programming in 24 Hours
     Microsoft Outlook 2000 E-mail and Fax Guide
Outlook and Exchange solutions at http://www.slipstick.com



Quote:
> Hello All,

> can someone provide me with a code (or multiple code samples) to do this
> ? :

> I have Task folder, containing a certain amount of IPM.Task. items (in
> customized forms)...

> Each IPM.Task.item that is created is ALWAYS linked with a contact
> (which is located on an Exchange server in a folder containing
> IPM.Contacts items).

> One of the custom field of this IPM.Task.form contains the contact's
> e-mail
> (I managed to display this e-mail directly in the task form using a
> little VBS script)

> So... I'd like to know how to program a VBA macro, which would "catch"
> (doing a sort of request, or filtering, or whatever....) all the emails
> linked to each task, and generate in a list format, or  a comma
> separated string, for exemple...,

> ...or, much better, open a blank e-mail, and "paste" all these e-mail
> addresses in the "to" or "copy" field !

> Thank you for your time, and your detailled help... as I'm a beginner...

> Very Best Regards,

> H

> --
> =======================================================
> Current digital authentication ID:****8416200011122****
> -------------------------------------------------------

> 9, rue Marcel Monge         / Home: +33(0)1 47 28 83 78
> F-92150 - Suresnes          / Mob:  +33(0)6 62 77 33 85
> Paris - France              / Work: +33(0)1 41 90 65 04
> =======================================================



Sun, 01 Jun 2003 00:48:05 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Working with VIM mail - Creating folders in cc:Mail

2. How to create a public folder journal item for user-selected e-mail messages

3. Changing from mail-item to task-item

4. How to Create Task Item in Someone Else's Task Folder

5. Converting mail items to task (outlook2002)

6. Notification when a new e-mail is sent to any e-mail Outlook folder

7. Need Outlook macro to recurse mail folders and print each item

8. fax-emails no Mail.Item?

9. Find the currently selected item in a mail folder

10. Move Selected Mail Items to Public Folder

11. Need to save a mail item to a public folder when it is sent

12. Search all folders for mail item

 

 
Powered by phpBB® Forum Software