A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Contacts, Distribution Lists and Searching



 
 
Thread Tools Display Modes
  #1  
Old January 19th, 2009, 04:39 PM posted to microsoft.public.outlook.contacts
AsianTiger
external usenet poster
 
Posts: 3
Default Contacts, Distribution Lists and Searching

I want to do a query on contacts based on involvement in a distribution
list. Is it possible?


Here are the specifics:
I have 300 contacts in a distribution list for an email newsletter.
I have 400 contacts that may or may not be in the email newsletter list
that I send a paper newsletter to These are in a "Mailing_List" category.
I want to do a query to find the addresses that are not in the email
distribution list, but are in the "Mailling_list" category...

Is there any way at all to do queries based on the participation in a
distribution list in outlook?

Thanks!

Outlook 2007 (Stand Alone - no exchange server)
Windows Vista

  #2  
Old January 19th, 2009, 07:06 PM posted to microsoft.public.outlook.contacts
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,346
Default Contacts, Distribution Lists and Searching



You'd need to code the solution yourself, e.g. with VBA.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Mon, 19 Jan 2009 11:39:18 -0500 schrieb AsianTiger:

I want to do a query on contacts based on involvement in a distribution
list. Is it possible?


Here are the specifics:
I have 300 contacts in a distribution list for an email newsletter.
I have 400 contacts that may or may not be in the email newsletter list
that I send a paper newsletter to These are in a "Mailing_List" category.
I want to do a query to find the addresses that are not in the email
distribution list, but are in the "Mailling_list" category...

Is there any way at all to do queries based on the participation in a
distribution list in outlook?

Thanks!

Outlook 2007 (Stand Alone - no exchange server)
Windows Vista

  #3  
Old January 19th, 2009, 08:12 PM posted to microsoft.public.outlook.contacts
AsianTiger
external usenet poster
 
Posts: 3
Default Contacts, Distribution Lists and Searching

unfortunately, I can't code...

Thanks anyway

"Michael Bauer [MVP - Outlook]" wrote in message
. ..


You'd need to code the solution yourself, e.g. with VBA.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Mon, 19 Jan 2009 11:39:18 -0500 schrieb AsianTiger:

I want to do a query on contacts based on involvement in a distribution
list. Is it possible?


Here are the specifics:
I have 300 contacts in a distribution list for an email newsletter.
I have 400 contacts that may or may not be in the email newsletter list
that I send a paper newsletter to These are in a "Mailing_List" category.
I want to do a query to find the addresses that are not in the email
distribution list, but are in the "Mailling_list" category...

Is there any way at all to do queries based on the participation in a
distribution list in outlook?

Thanks!

Outlook 2007 (Stand Alone - no exchange server)
Windows Vista


  #4  
Old January 20th, 2009, 02:32 AM posted to microsoft.public.outlook.contacts
Milly Staples [MVP - Outlook][_5_]
external usenet poster
 
Posts: 4,690
Default Contacts, Distribution Lists and Searching

Then check with http://www.outlookcode.com to see if any code already exists
to do what you want.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375

"AsianTiger" wrote in message
...
| unfortunately, I can't code...
|
| Thanks anyway
|
| "Michael Bauer [MVP - Outlook]" wrote in message
| . ..
|
|
| You'd need to code the solution yourself, e.g. with VBA.
|
| --
| Best regards
| Michael Bauer - MVP Outlook
|
| : Outlook Categories? Category Manager Is Your Tool
| : VBOffice Reporter for Data Analysis & Reporting
| : http://www.vboffice.net/product.html?pub=6&lang=en
|
|
| Am Mon, 19 Jan 2009 11:39:18 -0500 schrieb AsianTiger:
|
| I want to do a query on contacts based on involvement in a distribution
| list. Is it possible?
|
|
| Here are the specifics:
| I have 300 contacts in a distribution list for an email newsletter.
| I have 400 contacts that may or may not be in the email newsletter
list
| that I send a paper newsletter to These are in a "Mailing_List"
category.
| I want to do a query to find the addresses that are not in the email
| distribution list, but are in the "Mailling_list" category...
|
| Is there any way at all to do queries based on the participation in a
| distribution list in outlook?
|
| Thanks!
|
| Outlook 2007 (Stand Alone - no exchange server)
| Windows Vista
|


  #5  
Old January 20th, 2009, 03:11 AM posted to microsoft.public.outlook.contacts
AsianTiger
external usenet poster
 
Posts: 3
Default Contacts, Distribution Lists and Searching

Most Excellent Suggestion.

thanks.

"Milly Staples [MVP - Outlook]" what@ever wrote in message
...
Then check with http://www.outlookcode.com to see if any code already
exists
to do what you want.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375

"AsianTiger" wrote in message
...
| unfortunately, I can't code...
|
| Thanks anyway
|
| "Michael Bauer [MVP - Outlook]" wrote in message
| . ..
|
|
| You'd need to code the solution yourself, e.g. with VBA.
|
| --
| Best regards
| Michael Bauer - MVP Outlook
|
| : Outlook Categories? Category Manager Is Your Tool
| : VBOffice Reporter for Data Analysis & Reporting
| : http://www.vboffice.net/product.html?pub=6&lang=en
|
|
| Am Mon, 19 Jan 2009 11:39:18 -0500 schrieb AsianTiger:
|
| I want to do a query on contacts based on involvement in a
distribution
| list. Is it possible?
|
|
| Here are the specifics:
| I have 300 contacts in a distribution list for an email newsletter.
| I have 400 contacts that may or may not be in the email newsletter
list
| that I send a paper newsletter to These are in a "Mailing_List"
category.
| I want to do a query to find the addresses that are not in the
email
| distribution list, but are in the "Mailling_list" category...
|
| Is there any way at all to do queries based on the participation in
a
| distribution list in outlook?
|
| Thanks!
|
| Outlook 2007 (Stand Alone - no exchange server)
| Windows Vista
|



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.