A Microsoft Outlook email forum. Outlook Banter

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 » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do you do a mail merge using a category?



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old March 28th 06, 03:33 AM posted to microsoft.public.outlook.contacts
Maren
external usenet poster
 
Posts: 1
Default How do you do a mail merge using a category?

I am trying to make labels and I would like to use only the contacts in a
certain category. Does anyone have any suggestions for how to do this?
Ads
  #2  
Old March 28th 06, 08:05 PM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default How do you do a mail merge using a category?

Display your contacts folder with the By Category view.
Select the items in the desired category.
Choose Tools | Mail Merge.
Follow the prompts from there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Maren" wrote in message ...
I am trying to make labels and I would like to use only the contacts in a
certain category. Does anyone have any suggestions for how to do this?

  #3  
Old October 14th 06, 02:49 AM posted to microsoft.public.outlook.contacts
Info
external usenet poster
 
Posts: 11
Default How do you do a mail merge using a category?

I am trying to print mailing labels by selecting a specific category group
then doing a mail merge in Outlook 03. I understand all the steps but seem
to be missing something.....When I get to step 4, I choose Address block,
then when I click on Update Labels, I am getting a Yes Yes Yes on all the
labels and the addresses are not coming up for the selected category. What
am I missing here??

Thanks,
Mike

"Sue Mosher [MVP-Outlook]" wrote:

Display your contacts folder with the By Category view.
Select the items in the desired category.
Choose Tools | Mail Merge.
Follow the prompts from there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Maren" wrote in message ...
I am trying to make labels and I would like to use only the contacts in a
certain category. Does anyone have any suggestions for how to do this?


  #4  
Old October 14th 06, 03:24 AM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default How do you do a mail merge using a category?

I don't know what you mean by "a Yes Yes Yes." What I've seen is that sometimes the Update Labels command doesn't propagate the merge fields to all cells in the table correctly. So you might have to copy and paste the Address Block field manually into those cells that have just a Next Record field.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Info" wrote in message ...
I am trying to print mailing labels by selecting a specific category group
then doing a mail merge in Outlook 03. I understand all the steps but seem
to be missing something.....When I get to step 4, I choose Address block,
then when I click on Update Labels, I am getting a Yes Yes Yes on all the
labels and the addresses are not coming up for the selected category. What
am I missing here??

Thanks,
Mike

"Sue Mosher [MVP-Outlook]" wrote:

Display your contacts folder with the By Category view.
Select the items in the desired category.
Choose Tools | Mail Merge.
Follow the prompts from there.

"Maren" wrote in message ...
I am trying to make labels and I would like to use only the contacts in a
certain category. Does anyone have any suggestions for how to do this?


  #5  
Old October 14th 06, 03:56 AM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default How do you do a mail merge using a category?

All what steps? How are we supposed to know what steps you are following?
You cannot select a category for a mail merge unless you do so as the first
step and do the merge from Outlook.
--
Russ Valentine
[MVP-Outlook]
"Info" wrote in message
...
I am trying to print mailing labels by selecting a specific category group
then doing a mail merge in Outlook 03. I understand all the steps but
seem
to be missing something.....When I get to step 4, I choose Address block,
then when I click on Update Labels, I am getting a Yes Yes Yes on all the
labels and the addresses are not coming up for the selected category.
What
am I missing here??

Thanks,
Mike

"Sue Mosher [MVP-Outlook]" wrote:

Display your contacts folder with the By Category view.
Select the items in the desired category.
Choose Tools | Mail Merge.
Follow the prompts from there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Maren" wrote in message
...
I am trying to make labels and I would like to use only the contacts in
a
certain category. Does anyone have any suggestions for how to do this?




  #6  
Old October 14th 06, 04:18 PM posted to microsoft.public.outlook.contacts
Info
external usenet poster
 
Posts: 11
Default How do you do a mail merge using a category?

Russ,

Here are the specific steps I followed.
1. I begin in Outlook 03 in category view. I have categorized all my
contacts so I can choose specific ones for emails and mailing labels. I
highlight the category, then hit tools, then mail merge

2. I choose "Only Selected Contacts" & "Contact fields in Current View." In
merge options, I choose Mailing labels, click O.K

3. A box appears saying "Outlook has created a Mail Merge document and
prepared your contact data for you. In order to complete the setup for
Mailing labels you have to press the "setup button" in section 1 of the Mail
Merge helper dialog. I click O.K

4. The Mail Merge helper comes up, the Mailing labels are chosed, label size
(8160) data source has already been selected, I hit Cancel. Now I have a
blank label screen in Word. I go to Tools, Letters and Mailings, then Mail
Merge.

5. The table on the right side pops up, Under Select Recipients, I choose
use an existing client list (its selected by default). I click Step 3 of 6
(Arrange Your Labels) Under Arrange your labels, I choose Address Block, then
Hit O.K, the Address Block appears in the first label on the sheet.

6. Under Replicate Labels, I click update all labels, when I click preview
your labels (Step 4 of 6) I get a blank screen. Do I have to Merge a field
or something. Why are the addresses not coming up??

Thanks,
Mike

3.

"Russ Valentine [MVP-Outlook]" wrote:

All what steps? How are we supposed to know what steps you are following?
You cannot select a category for a mail merge unless you do so as the first
step and do the merge from Outlook.
--
Russ Valentine
[MVP-Outlook]
"Info" wrote in message
...
I am trying to print mailing labels by selecting a specific category group
then doing a mail merge in Outlook 03. I understand all the steps but
seem
to be missing something.....When I get to step 4, I choose Address block,
then when I click on Update Labels, I am getting a Yes Yes Yes on all the
labels and the addresses are not coming up for the selected category.
What
am I missing here??

Thanks,
Mike

"Sue Mosher [MVP-Outlook]" wrote:

Display your contacts folder with the By Category view.
Select the items in the desired category.
Choose Tools | Mail Merge.
Follow the prompts from there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Maren" wrote in message
...
I am trying to make labels and I would like to use only the contacts in
a
certain category. Does anyone have any suggestions for how to do this?




  #7  
Old October 14th 06, 07:02 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default How do you do a mail merge using a category?

Why are you doing step 5? You selected your recipients at the beginning.
In Outlook/Word 2002/2003 there is an extra step required to create mailing
labels. Instructions he
http://support.microsoft.com/?kbid=284401

--
Russ Valentine
[MVP-Outlook]
"Info" wrote in message
...
Russ,

Here are the specific steps I followed.
1. I begin in Outlook 03 in category view. I have categorized all my
contacts so I can choose specific ones for emails and mailing labels. I
highlight the category, then hit tools, then mail merge

2. I choose "Only Selected Contacts" & "Contact fields in Current View."
In
merge options, I choose Mailing labels, click O.K

3. A box appears saying "Outlook has created a Mail Merge document and
prepared your contact data for you. In order to complete the setup for
Mailing labels you have to press the "setup button" in section 1 of the
Mail
Merge helper dialog. I click O.K

4. The Mail Merge helper comes up, the Mailing labels are chosed, label
size
(8160) data source has already been selected, I hit Cancel. Now I have a
blank label screen in Word. I go to Tools, Letters and Mailings, then
Mail
Merge.

5. The table on the right side pops up, Under Select Recipients, I choose
use an existing client list (its selected by default). I click Step 3 of
6
(Arrange Your Labels) Under Arrange your labels, I choose Address Block,
then
Hit O.K, the Address Block appears in the first label on the sheet.

6. Under Replicate Labels, I click update all labels, when I click preview
your labels (Step 4 of 6) I get a blank screen. Do I have to Merge a
field
or something. Why are the addresses not coming up??

Thanks,
Mike

3.

"Russ Valentine [MVP-Outlook]" wrote:

All what steps? How are we supposed to know what steps you are following?
You cannot select a category for a mail merge unless you do so as the
first
step and do the merge from Outlook.
--
Russ Valentine
[MVP-Outlook]
"Info" wrote in message
...
I am trying to print mailing labels by selecting a specific category
group
then doing a mail merge in Outlook 03. I understand all the steps but
seem
to be missing something.....When I get to step 4, I choose Address
block,
then when I click on Update Labels, I am getting a Yes Yes Yes on all
the
labels and the addresses are not coming up for the selected category.
What
am I missing here??

Thanks,
Mike

"Sue Mosher [MVP-Outlook]" wrote:

Display your contacts folder with the By Category view.
Select the items in the desired category.
Choose Tools | Mail Merge.
Follow the prompts from there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Maren" wrote in message
...
I am trying to make labels and I would like to use only the contacts
in
a
certain category. Does anyone have any suggestions for how to do
this?





  #8  
Old October 14th 06, 09:06 PM posted to microsoft.public.outlook.contacts
Info
external usenet poster
 
Posts: 11
Default How do you do a mail merge using a category?

In Step 7 of the instructions, I click Insert Merge Fields, do I insert
Database fields or Address Fields? I am assuming address fields, I'm not
sure what to select but I selected Address 1, clicked Insert, the Close. I
do not see anywhere to click Propogate Labels (as instructed in Step 8)???

"Russ Valentine [MVP-Outlook]" wrote:

Why are you doing step 5? You selected your recipients at the beginning.
In Outlook/Word 2002/2003 there is an extra step required to create mailing
labels. Instructions he
http://support.microsoft.com/?kbid=284401

--
Russ Valentine
[MVP-Outlook]
"Info" wrote in message
...
Russ,

Here are the specific steps I followed.
1. I begin in Outlook 03 in category view. I have categorized all my
contacts so I can choose specific ones for emails and mailing labels. I
highlight the category, then hit tools, then mail merge

2. I choose "Only Selected Contacts" & "Contact fields in Current View."
In
merge options, I choose Mailing labels, click O.K

3. A box appears saying "Outlook has created a Mail Merge document and
prepared your contact data for you. In order to complete the setup for
Mailing labels you have to press the "setup button" in section 1 of the
Mail
Merge helper dialog. I click O.K

4. The Mail Merge helper comes up, the Mailing labels are chosed, label
size
(8160) data source has already been selected, I hit Cancel. Now I have a
blank label screen in Word. I go to Tools, Letters and Mailings, then
Mail
Merge.

5. The table on the right side pops up, Under Select Recipients, I choose
use an existing client list (its selected by default). I click Step 3 of
6
(Arrange Your Labels) Under Arrange your labels, I choose Address Block,
then
Hit O.K, the Address Block appears in the first label on the sheet.

6. Under Replicate Labels, I click update all labels, when I click preview
your labels (Step 4 of 6) I get a blank screen. Do I have to Merge a
field
or something. Why are the addresses not coming up??

Thanks,
Mike

3.

"Russ Valentine [MVP-Outlook]" wrote:

All what steps? How are we supposed to know what steps you are following?
You cannot select a category for a mail merge unless you do so as the
first
step and do the merge from Outlook.
--
Russ Valentine
[MVP-Outlook]
"Info" wrote in message
...
I am trying to print mailing labels by selecting a specific category
group
then doing a mail merge in Outlook 03. I understand all the steps but
seem
to be missing something.....When I get to step 4, I choose Address
block,
then when I click on Update Labels, I am getting a Yes Yes Yes on all
the
labels and the addresses are not coming up for the selected category.
What
am I missing here??

Thanks,
Mike

"Sue Mosher [MVP-Outlook]" wrote:

Display your contacts folder with the By Category view.
Select the items in the desired category.
Choose Tools | Mail Merge.
Follow the prompts from there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Maren" wrote in message
...
I am trying to make labels and I would like to use only the contacts
in
a
certain category. Does anyone have any suggestions for how to do
this?





  #9  
Old October 14th 06, 09:29 PM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default How do you do a mail merge using a category?

If you want all the fields available in an OUtlook contact, use Database fields.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Info" wrote in message ...
In Step 7 of the instructions, I click Insert Merge Fields, do I insert
Database fields or Address Fields? I am assuming address fields, I'm not
sure what to select but I selected Address 1, clicked Insert, the Close. I
do not see anywhere to click Propogate Labels (as instructed in Step 8)???

"Russ Valentine [MVP-Outlook]" wrote:

Why are you doing step 5? You selected your recipients at the beginning.
In Outlook/Word 2002/2003 there is an extra step required to create mailing
labels. Instructions he
http://support.microsoft.com/?kbid=284401

--
Russ Valentine
[MVP-Outlook]
"Info" wrote in message
...
Russ,

Here are the specific steps I followed.
1. I begin in Outlook 03 in category view. I have categorized all my
contacts so I can choose specific ones for emails and mailing labels. I
highlight the category, then hit tools, then mail merge

2. I choose "Only Selected Contacts" & "Contact fields in Current View."
In
merge options, I choose Mailing labels, click O.K

3. A box appears saying "Outlook has created a Mail Merge document and
prepared your contact data for you. In order to complete the setup for
Mailing labels you have to press the "setup button" in section 1 of the
Mail
Merge helper dialog. I click O.K

4. The Mail Merge helper comes up, the Mailing labels are chosed, label
size
(8160) data source has already been selected, I hit Cancel. Now I have a
blank label screen in Word. I go to Tools, Letters and Mailings, then
Mail
Merge.

5. The table on the right side pops up, Under Select Recipients, I choose
use an existing client list (its selected by default). I click Step 3 of
6
(Arrange Your Labels) Under Arrange your labels, I choose Address Block,
then
Hit O.K, the Address Block appears in the first label on the sheet.

6. Under Replicate Labels, I click update all labels, when I click preview
your labels (Step 4 of 6) I get a blank screen. Do I have to Merge a
field
or something. Why are the addresses not coming up??

Thanks,
Mike

3.

"Russ Valentine [MVP-Outlook]" wrote:

All what steps? How are we supposed to know what steps you are following?
You cannot select a category for a mail merge unless you do so as the
first
step and do the merge from Outlook.
--
Russ Valentine
[MVP-Outlook]
"Info" wrote in message
...
I am trying to print mailing labels by selecting a specific category
group
then doing a mail merge in Outlook 03. I understand all the steps but
seem
to be missing something.....When I get to step 4, I choose Address
block,
then when I click on Update Labels, I am getting a Yes Yes Yes on all
the
labels and the addresses are not coming up for the selected category.
What
am I missing here??

Thanks,
Mike

"Sue Mosher [MVP-Outlook]" wrote:

Display your contacts folder with the By Category view.
Select the items in the desired category.
Choose Tools | Mail Merge.
Follow the prompts from there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Maren" wrote in message
...
I am trying to make labels and I would like to use only the contacts
in
a
certain category. Does anyone have any suggestions for how to do
this?





  #10  
Old October 14th 06, 10:37 PM posted to microsoft.public.outlook.contacts
Info
external usenet poster
 
Posts: 11
Default How do you do a mail merge using a category?

OK, what do I choose in the Database field? I chose Full Name then in the
Address field I chose Address 1 then when I go to replicate all the lables,
the fields come up but when I go to merge only the persons name is coming up
in all the tabs. Why isn't the entire mailing address coming up in all the
tabs?

"Sue Mosher [MVP-Outlook]" wrote:

If you want all the fields available in an OUtlook contact, use Database fields.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Info" wrote in message ...
In Step 7 of the instructions, I click Insert Merge Fields, do I insert
Database fields or Address Fields? I am assuming address fields, I'm not
sure what to select but I selected Address 1, clicked Insert, the Close. I
do not see anywhere to click Propogate Labels (as instructed in Step 8)???

"Russ Valentine [MVP-Outlook]" wrote:

Why are you doing step 5? You selected your recipients at the beginning.
In Outlook/Word 2002/2003 there is an extra step required to create mailing
labels. Instructions he
http://support.microsoft.com/?kbid=284401

--
Russ Valentine
[MVP-Outlook]
"Info" wrote in message
...
Russ,

Here are the specific steps I followed.
1. I begin in Outlook 03 in category view. I have categorized all my
contacts so I can choose specific ones for emails and mailing labels. I
highlight the category, then hit tools, then mail merge

2. I choose "Only Selected Contacts" & "Contact fields in Current View."
In
merge options, I choose Mailing labels, click O.K

3. A box appears saying "Outlook has created a Mail Merge document and
prepared your contact data for you. In order to complete the setup for
Mailing labels you have to press the "setup button" in section 1 of the
Mail
Merge helper dialog. I click O.K

4. The Mail Merge helper comes up, the Mailing labels are chosed, label
size
(8160) data source has already been selected, I hit Cancel. Now I have a
blank label screen in Word. I go to Tools, Letters and Mailings, then
Mail
Merge.

5. The table on the right side pops up, Under Select Recipients, I choose
use an existing client list (its selected by default). I click Step 3 of
6
(Arrange Your Labels) Under Arrange your labels, I choose Address Block,
then
Hit O.K, the Address Block appears in the first label on the sheet.

6. Under Replicate Labels, I click update all labels, when I click preview
your labels (Step 4 of 6) I get a blank screen. Do I have to Merge a
field
or something. Why are the addresses not coming up??

Thanks,
Mike

3.

"Russ Valentine [MVP-Outlook]" wrote:

All what steps? How are we supposed to know what steps you are following?
You cannot select a category for a mail merge unless you do so as the
first
step and do the merge from Outlook.
--
Russ Valentine
[MVP-Outlook]
"Info" wrote in message
...
I am trying to print mailing labels by selecting a specific category
group
then doing a mail merge in Outlook 03. I understand all the steps but
seem
to be missing something.....When I get to step 4, I choose Address
block,
then when I click on Update Labels, I am getting a Yes Yes Yes on all
the
labels and the addresses are not coming up for the selected category.
What
am I missing here??

Thanks,
Mike

"Sue Mosher [MVP-Outlook]" wrote:

Display your contacts folder with the By Category view.
Select the items in the desired category.
Choose Tools | Mail Merge.
Follow the prompts from there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Maren" wrote in message
...
I am trying to make labels and I would like to use only the contacts
in
a
certain category. Does anyone have any suggestions for how to do
this?






 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
For a mail merge, can I sort by category using Outlook contacts? katie Outlook - Using Contacts 5 March 3rd 06 02:56 PM
How do you filter a mail merge by category? JMF Outlook - Using Contacts 1 February 25th 06 05:51 AM
Contacts/Category Mail Merge Patrice Outlook - Using Contacts 17 February 15th 06 11:44 PM
Mail Merge Problem Donna in Idaho Outlook - Using Contacts 2 February 7th 06 10:04 AM
Contact Mail Merge WHGeorge Outlook - Using Contacts 1 January 18th 06 10:18 AM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.