Category to Distribution List

Dear All:

A: Outlook 2003
B: OS = XP

Is there a way to create a Distribution List from a category ?

I have a number of clients in special categories ( usually company name)

However, there are times when I want to send BCC to several clients
and would like to find a way to send that email without having to
insert all the names. The category list of names can only be in
the To: portion of the outgoing email.

Suggestions highly appreciated.

John A Hansen



0
jahansen6 (22)
7/8/2007 12:09:42 PM
outlook 87535 articles. 11 followers. Follow

3 Replies
425 Views

Similar Articles

[PageSpeed] 42

Two methods, both starting with the folder grouped by category, and all =
the items in the category selected:=20

1) Choose Actions | New Message to Contact, then cut and paste the names =
from the To to the Cc box.=20

2) Choose Tools | Mail Merge and perform a mail merge to email output.=20

#2 will give the best results -- individual messages addressed directly =
to each recipient.=20

--=20
Sue Mosher, Outlook MVP
   Author of Microsoft Outlook 2007 Programming:
     Jumpstart for Power Users and Administrators
    http://www.outlookcode.com/article.aspx?id=3D54=20


"John A Hansen" <jahansen6@comcast.net> wrote in message =
news:BIWdnf34IuOUSQ3bnZ2dnUVZ_v-tnZ2d@comcast.com...
>=20
> Dear All:
>=20
> A: Outlook 2003
> B: OS =3D XP
>=20
> Is there a way to create a Distribution List from a category ?
>=20
> I have a number of clients in special categories ( usually company =
name)
>=20
> However, there are times when I want to send BCC to several clients
> and would like to find a way to send that email without having to
> insert all the names. The category list of names can only be in
> the To: portion of the outgoing email.
>=20
> Suggestions highly appreciated.
>=20
> John A Hansen
>=20
>=20
>
0
suemvp (4038)
7/8/2007 12:46:59 PM
There is, but it requires several steps.
1. Copy your Category members into their own subfolder and enable that 
subfolder as an email address book.
2. When you create a new DL, use that subfolder as your source in the Select 
members dialog, select all Contacts and add them to the DL.

I think most people prefer to stick with categories and just do a cut and 
paste from the To: field to the BCC field.
-- 
Russ Valentine
[MVP-Outlook]
"John A Hansen" <jahansen6@comcast.net> wrote in message 
news:BIWdnf34IuOUSQ3bnZ2dnUVZ_v-tnZ2d@comcast.com...
>
> Dear All:
>
> A: Outlook 2003
> B: OS = XP
>
> Is there a way to create a Distribution List from a category ?
>
> I have a number of clients in special categories ( usually company name)
>
> However, there are times when I want to send BCC to several clients
> and would like to find a way to send that email without having to
> insert all the names. The category list of names can only be in
> the To: portion of the outgoing email.
>
> Suggestions highly appreciated.
>
> John A Hansen
>
>
> 

0
russval1 (2100)
7/8/2007 12:56:31 PM
Russ:
I merely enabled the subfolder as a email address book
and then created the DL. Worked perfectly.

Thanks so much.

John


"Russ Valentine [MVP-Outlook]" <russval@gmail.com> wrote in message 
news:72953756-78FA-4552-B0D7-E63550880BB9@microsoft.com...
> There is, but it requires several steps.
> 1. Copy your Category members into their own subfolder and enable that 
> subfolder as an email address book.
> 2. When you create a new DL, use that subfolder as your source in the 
> Select members dialog, select all Contacts and add them to the DL.
>
> I think most people prefer to stick with categories and just do a cut and 
> paste from the To: field to the BCC field.
> -- 
> Russ Valentine
> [MVP-Outlook]
> "John A Hansen" <jahansen6@comcast.net> wrote in message 
> news:BIWdnf34IuOUSQ3bnZ2dnUVZ_v-tnZ2d@comcast.com...
>>
>> Dear All:
>>
>> A: Outlook 2003
>> B: OS = XP
>>
>> Is there a way to create a Distribution List from a category ?
>>
>> I have a number of clients in special categories ( usually company name)
>>
>> However, there are times when I want to send BCC to several clients
>> and would like to find a way to send that email without having to
>> insert all the names. The category list of names can only be in
>> the To: portion of the outgoing email.
>>
>> Suggestions highly appreciated.
>>
>> John A Hansen
>>
>>
>>
> 


0
jahansen6 (22)
7/8/2007 11:33:11 PM
Reply:

Similar Artilces:

making charts based on text categories
I have a column of nationalities and I want to make a pie chart to show the percentage of each nationality. How do I do this? Suppose you have this data in A1:B3 ABC 900 XYZ 1000 DEF 800 (Ref your subject line, you'd of course need the population *numbers* next to the nationalities to plot the pie) Select A1:B3 Click the "Chart Wizard" button Choose "Pie" > select the desired sub-type Click Next and run through/complete the steps of the wizard -- Rgds Max xl 97 --- GMT+8, 1� 22' N 103� 45' E xdemechanik <at>yahoo<dot>com ---- "cwling&...

combo box list shortcut
Hi I have a combo box on a VBA data entry form. One of the validated lists is approx 100 names long and is a pain scrolling through. Is it possible to maybe enter the first letter of the name and bring up only those beginning with that letter ? -- thanks Roy There's a MatchEntry property for the combobox. Try changing it to fmMatchEntryFirstLetter (either in code or via the properties window. Roy Gudgeon wrote: > > Hi > > I have a combo box on a VBA data entry form. One of the validated lists is > approx 100 names long and is a pain scroll...

Formatting Address List names
Is it posible to bold or otherwise format the address list names in Exchange 2003? I have nested address lists such as company, division, department , and wish to highlight the address list names. I also wish to sort the lists in non alphabetic order Thank Katarina ...

Unable to change category group
Hi I'm using Money 2004. I am unable to change the category group for a category called INTEREST which is in under Income. I am getting a message stating "This category is mapped to the capital gains investment category. It's tax line cannot be changed". I dont understand why I cannot change it to "Periodic Income". Please can you advise. Thank you. You can't. See http://money.mvps.org/faq/article/69.aspx -- Regards Bob Peel, Microsoft MVP - Money For UK tips & fixes see http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny. I do no...

List<>...the saving of
The next thing Ive learning about is Lists and generic Lists in = particular and one thing I`ve been wondering is how you actually save these lists so = that the contents are available the next time you run the app. Ive had a = quick google and come across Serialization (binary) which looks from first glance like it would do the trick. Am I on the right track or is there = some other way that is generally used? TIA, mick Go for it! However I'm a bigger fan of XML Serialization, but to each his own. "mick" <coughcough@privacy.com> wrote in message news...

Add to new Entity Price List
We are trying to create a new Entity in the module Customizable Entities, in the page Relationships we are trying to use the table name PriceList but this table is missing in the dropdown text . Could you please let me know how can I found this table in the Relationships page? Thanks, Anatoli P ...

Lists Box
I have a form with fields; ID, DATE and QUANTITY. The Date andQuantity Field I've changed into a List Box showing the two columnsrespectively and the ID field is left as a normal text box. When Iclick on any item in the list box the ID change change according towhich ever entry I have selected. Unfortunetly ID field staysconstant!!Any suggestionsThanks Hi, Asif,did you include the ID field in the ListBox?The easiest solution:1) Add the ID field to the RowSource.2) Point the BoundColumn to the ID field.3) Set the ID field column width to 0.HTHVlado"Asif" <asifhashmani@hotmail.c...

Multiple Tables in Query not Listing Data.
I cannot seem to get this correct. I am trying to run a query on two databases one of which is linked to the other. I am trying to get the query to display a 0 for the total defects counted from one table based on the date and time from another table. So far when I run the query I get only the counts from the values that are not null. Here is the SQL Statement: SELECT Pro_Total_by_Cell.Cell, Pro_Total_by_Cell.Shift, Pro_Total_by_Cell.Time, Pro_Total_by_Cell.ProTotal, Pro_Total_by_Cell.Time1, Hourly_Defects_by_Cell3.CountofFC, Control_Limit_by_Cell.UCL, IIf(IsNull([Counto...

The reports assistant only list the first field of any table
Hi everybody. I have installed access 2003 in a machine running windows XP, and I have a problem with the report and forms assistant. It only lists the first field of any table I choose to be reported, so I cannot use it for my reports or forms. I have instaled SP2 for WinXP, and I have also tried to uninstall it. Is there any SP or something that I am missing? Thanks a lot in advance! Nacho -- Message posted via http://www.accessmonster.com Hi, My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups. Is your form and report wizards not working? To try to reso...

Removing a list of data from a larger one
I just can't figure out how to remove our smaller, e-mail remove list from our much larger e-mail send list. I have the two lists and want to remove the ones in the 'remove' list from our current e-mail list. I'm sure there is an easy way to do this, I just can't figure it out. Any help would be greatly appreciated and I'm sorry if it seems vague but that's about the best I can explain it. Thanks, Bryan. Visit Chip Pearson's duplicates site for methods of highlighting, tagging, replacing duplicates. http://www.cpearson.com/excel/duplicat.htm Gord Di...

Outlook clients can not list global distribution list members
Client PC running WindowsXP can no longer see or update members of Outlook global distribution lists. This is a NT 4 domain running Exchange 5.5, all with current patches. Problem does not appear to be related to the version of Outlook. Clients running Win2000, Win9x, and Outlook 98 - XP 2003 can see the lists. Only the WinXP Pro clients have the problem. ...

"referrer" entries in an alaphabetic list
I have a report which produces an alphabetic directory of names. is there a simple way to insert a record along the lines of "Wife's last name, see other last name under a different letter grouping"? The challenge is that the report is created from multiple linked queries, such that the final query is actually just the children records, and we read the family name and address (which is the heading) off the first child record for each family. Post your table structure with field names and datatype. Post sample data and example of what you want as an output. ...

changing the message list in outlook 2003
i just upgraded from office 2000 to 2003. in the message look in outlook, it separates the messages by date. is there any way to turn this off, so i just have a long list of messages? Right click on the header in the message list, uncheck "show in groups." --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the SWEN virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Lee Benningfield asked: | i just upgraded from office 2000 to 2003. in the mess...

Name suppression in an Outlook Distribution List
Would appreciate some help with how to suppress names/email address when creating a distribution list in Outlook 2000 so that other members on the list can not see the individual names or email addresses of each person. Want each person to just see the name of the distribution list - for example - "Meeting Update List" Thank you. ...

Email list management
Greetings from NJ! I would like to email several people at a time in a politcally correct (privacy-compassionate) way. I do not want to put all their addresses in the "to:" as their privacy is compromised. If I use a distribution list, their names still show up on the actual email. If I use "bcc", my own email address seems to be inserted in the "to:" address of each email, but otherwise it seems private. THE PROBLEM is that some email systems reject an email not directed specifically at the recipient. When my email address is in the "to:" and...

Text size in a drop-down list
I have created a drop down list using the Data>>Validation feature. The list is pulled from a range of values in the spreadsheet and a drop-down appears on each cell where the data validation is set. The problem I have is that the list text is very small, maybe 8 points. Changing the source data or the size of the validated cells makes no difference. Changing Excel default settings or Normal style text size settings doesn't make a difference. Does anyone know how to change the text size so that we can read the drop down text? A workaround http://www.contextures.com/x...

Is there a limit to Junk Senders list?
Is there a limit to Junk Senders list? I must have a thousand or so. How many will it effectively take? I think the Junk Senders.TXT file can be 32K in size "Millwork" <philfcsnospam@hotmail.com> wrote in message news:FdUnb.7973$8x2.4512126@newssrv26.news.prodigy.com... > Is there a limit to Junk Senders list? I must have a thousand or so. How > many will it effectively take? Well my file is 75 KB, so I suppose I'm wasting my time adding any more. "Millwork" <philfcsnospam@hotmail.com> wrote in message news:FdUnb.7973$8x2.4512126@newssrv26....

Generating a list dependent on specific criteria
Hi, I am working on a large register of equipment and have a problem. I need to create a list automatically based on the contents in one cell. I have a equipment register on one sheet (Sheet 1) and wish a list to be automatically generated via the info in a cell on Sheet 2, ive tried to show what I mean below. Sheet 1 data: A B C D 1 Drill Yellow Parent Blue 2 Drill Yellow Child Blue 3 Drill Yellow Child ...

List Box
I am stumped and need some assistance - PLEASE. New to List Boxes. I have created two unbound list boxes on an unbound form to use as criteria for a report. Both list boxes (lboxCategory and lboxSupplier) have two fields CategoryID and Category and SupplierID and Supplier sorting ascending on latter fields. The Multi-Select property is set to Extended. I have a command button cmdPreview that I would like to use to preview the report after selections are made. I will select two or more choices from each list box at a time. Can anyone get me started with the code I need to make this h...

No Banks listed
I upgraded to 2006 today, and in the set up accounts, i am not getting bank lists to pick my bank. all i get is "this is not available at the time, check back later" how do i correct this. I get it all the time. any ideas guys?? ...

keep lover level bullet list with previous bullet
Word 2007. I have a Heading then some paragraphs. Then a bullet list. How do I prevent a page from breaking in the middle of a lower level bullet list? In other words, how do I keep lower level bullets with it's upper level? For example: Many paragraphs o upper level bullet aaa - one aaa - two aaa - three aaa o upper level bbb - one bbb - two bbb - three bbb Right now I run out of room on the page and -two bbb goes to the next page. I can highlight the "bbb"s and under Paragraph/line and Page Breaks check Keep Lines Together. I may nee...

Formula to display Count of Days in given month, using list of Start and End Dates
I have a large number of rows that contain a start date and end date. I am attempting to generate a count of days within that date range that are in a particular month, for example, Jan of 2011. Any suggestions for a formula that could be used to display the amounts shown in Column C would be helpful. Layout is: A B C Start Date End Date Count of Days in Jan2011 1/10/11 4/7/11 21 2/6/11 3/1/11 0 12/20/10 2/15/11 31 Etc. Dave, I think the best way is to create a table f...

Setting the default Price List
Hi, Currently we are only have 1 price list defined in the system. Is it possible that on Opportunity form, the value of price list is automatically updated to the one that we defined?? How to accomplish this requirement?? Carrie only thing that you can do to avoid re-entering the pricelist is is enter the default price list for each account etc. That means you enter it once for each account then never have to enter it again when you create a new opportunity against the account "Carrie" <Carrie@discussions.microsoft.com> wrote in message news:6C73FC86-BCE9-4F84-92C1-...

Linking income to a specific budget category
I rent a house with three roommates and am responsible for paying the utility bills. For each bill, I pay the full amount from my own checking account but then receive 75% of it back from the other three roommates. How can I accurately track these transactions, so my budget reflects that I'm really only paying $25 for the electricity bill, and not the full $100? FAQ. Create a bank/cash account called 'money owed me'. On the account details page, check the box that makes it a 'budget' account. Pay the utility bills from your checking account, categorized as split....

Query Based Distribution Lists #3
I can create QBDL based on STATE, ZIP, LASTNAME and many other fields. I would like to make a list based on Group Membership. There is a field under USER called MEMBER OF but it does not give me any results when I do a preview. I have many employees who work in multiple locations and need to belong to several different groups even though they have only one login and work out of a single office with the same address etc. So I made them members of groups based on the different location in which they work and wanted to send mail based on this membership. McMurray <McMurray@disc...