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
  #11  
Old October 14th 06, 10:38 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, I chose Full Name in the Database field and Address 1 in the Address
field. When I go to replicate all the labels and do the merge, only the
persons name is coming up. Why isn't the entire mailing address coming up?

"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?






Ads
  #12  
Old October 15th 06, 01:22 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've never mixed fields from the two lists like that.

Did you see my earlier tip on copying the AddressBlock field? The same would apply to other fields if you use them instead, if the Update All Labels command doesn't do it for you automatically.

--
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 ...
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.



"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?






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

I would of never thought doing a mail merge by category would be so
difficult. I have followed every step precisely. I have my Outlook contacts
sorted by Category and I want to print mailing labels for each category. The
AddressBlock field is in view, when I go to do the merge, my tabs are
blank

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, the AddressBlock appears in all the tabs.....when I click preview
your labels (Step 4 of 6) I get a blank screen. Do I have to Merge a different field or something. Why are the addresses not coming up??



"Sue Mosher [MVP-Outlook]" wrote:

I've never mixed fields from the two lists like that.

Did you see my earlier tip on copying the AddressBlock field? The same would apply to other fields if you use them instead, if the Update All Labels command doesn't do it for you automatically.

--
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 ...
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.



"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?







  #14  
Old November 25th 07, 01:44 AM posted to microsoft.public.outlook.contacts
John A
external usenet poster
 
Posts: 2
Default How do you do a mail merge using a category?

Excuse me for butting in but I cannot understand how to post a question of my
own. If I click New, there are 3 choices but no windows opens allowing me to
enter my text. It's probably as obvious but I need help.
--
Thanks for your help


"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?


  #15  
Old November 25th 07, 02:10 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?

Could you at least post a coherent question?
--
Russ Valentine
[MVP-Outlook]
"John A" wrote in message
...
Excuse me for butting in but I cannot understand how to post a question of
my
own. If I click New, there are 3 choices but no windows opens allowing me
to
enter my text. It's probably as obvious but I need help.
--
Thanks for your help


"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.