Using Contacts Category as list for printing labels
  Home FAQ Contact Sign in
microsoft.public.outlook.contacts only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... contacts Profile…
 Up
Using Contacts Category as list for printing labels         


Author: Leslie
Date: Aug 26, 2008 19:07

I'm confused on how to import the individuals from a specific category into
mailing labels. What I've done so far: Highlighted the list from a specific
category. I'm using Avery mailing labels and formed a template that says
"New Record" for each of the labels. In Outlook, I clicked on Mail Merge and
specified the Avery label 5160. In the "address block", I determined the
fields needed; i.e. first name, last name, 1st address, city, state, etc. I
cannot figure out how to get the individuals I highlighted in a specific
Outlook Category into the Word doc template. I hope this is clear. Thank
you,
--
Leslie
15 Comments
Re: Using Contacts Category as list for printing labels         


Date: Aug 26, 2008 20:27

Close Word, open Outlook
Highlight the Contacts as you described
Tools
Mailmerge
To labels
I think you'll kbnow what to do from there - set the type of label etc.

Regards

Judy Gleeson
MVP Outlook

If you have 2 minutes I would appreciate some feedback through this survey
link.
http://www.surveymonkey.com/s.aspx?sm=6BcZ_2fDS9y_2fwsicQUr5wGQQ_3d_3d

www.judygleeson.com
www.deskdoctors.com
Want to be more productive? Outlook 2003 user? Read "7 settings all Outlook
2003 users should change" at www.pragmatix.com.au

SOON!
launching in August 2008:
www.executiveassistantsonline.com
Show full article (1.38Kb)
no comments
Re: Using Contacts Category as list for printing labels         


Author: Leslie
Date: Aug 26, 2008 20:54

I'm still confused. I can't get the fields to download into the word doc
template. Sorry. I'm using Outlook 2007.
--
Leslie

"Judy Gleeson (MVP Outlook)" wrote:
> Close Word, open Outlook
> Highlight the Contacts as you described
> Tools
> Mailmerge
> To labels
> I think you'll kbnow what to do from there - set the type of label etc.
>
> Regards
>
> Judy Gleeson...
Show full article (1.65Kb)
no comments
Re: Using Contacts Category as list for printing labels         


Author: Leslie
Date: Aug 26, 2008 20:59

I'm also using Windows Vista Premium in case that helps.
--
Leslie

"Leslie" wrote:
> I'm still confused. I can't get the fields to download into the word doc
> template. Sorry. I'm using Outlook 2007.
> --
> Leslie
>
>
> "Judy Gleeson (MVP Outlook)" wrote:
>
>> Close Word...
Show full article (1.85Kb)
no comments
Re: Using Contacts Category as list for printing labels         


Date: Aug 27, 2008 04:07

At what point in the setps I described does something go wrong? What result
do you get?

Regards

Judy Gleeson
MVP Outlook

If you have 2 minutes I would appreciate some feedback through this survey
link.
http://www.surveymonkey.com/s.aspx?sm=6BcZ_2fDS9y_2fwsicQUr5wGQQ_3d_3d

www.judygleeson.com
www.deskdoctors.com
Want to be more productive? Outlook 2003 user? Read "7 settings all Outlook
2003 users should change" at www.pragmatix.com.au

SOON!
launching in August 2008:
www.executiveassistantsonline.com

.
"Leslie" discussions.microsoft.com> wrote in message
news:8DF3F9B8-ABAC-4C86-BD6F-02778039F14E@microsoft.com...
> I'm also using Windows Vista Premium in case that helps.
> --
> Leslie
>
>...
Show full article (2.62Kb)
no comments
Re: Using Contacts Category as list for printing labels         


Author: Leslie
Date: Aug 27, 2008 08:17

Some of the steps I've taken:
Mail Merge contacts: only selected contacts
Document file: New document
Merge Options: Merge to: Mailing labels
Initializing Word Doc
Word: Click Setup button in Section 1 of the mailmerge helper dialog
1: Main document: Create Mailing Labels
Setup: 5160
2: Date Source: Options are: Create Data Source, Open Data Source, Use
Address Book, Header Options (I've tried to use all of these choices) In
Header Options I removed all fields except FirstName, LastName, Address1,
City, State, Zip. When I tried to Create Data Source??? Open Data
Source???? Use Address Book - didn't bring up my Contacts Category that I'd
highlighted.
3: Merge the data with the document: Merge (is grayed); Query Options button
So, it appears #2 and #3 is where I'm stumped...
Show full article (2.62Kb)
no comments
Re: Using Contacts Category as list for printing labels         


Date: Aug 28, 2008 00:25

You have not followed my instructions.
Close Word.
Start in Outlook
Select the Contacts.
Just follow the steps I gave you!

Starting in Word makes it much more difficult than it needs to be. I never
do it that way.

Regards

Judy Gleeson
MVP Outlook

If you have 2 minutes I would appreciate some feedback through this survey
link.
http://www.surveymonkey.com/s.aspx?sm=6BcZ_2fDS9y_2fwsicQUr5wGQQ_3d_3d

www.judygleeson.com
www.deskdoctors.com
Want to be more productive? Outlook 2003 user? Read "7 settings all Outlook
2003 users should change" at www.pragmatix.com.au
Show full article (3.54Kb)
no comments
Re: Using Contacts Category as list for printing labels         


Author: Leslie
Date: Aug 28, 2008 09:32

Judy, I did not have Word open. It opened automatically. I'll start again.
Word is closed.
Highlight records from Outlook Category.
Tools, Mail Merge, Mailing Labels, "OK"
Outlook created a mail merge document (Word) and prepared your contact data
for you. To complete the setup for Mailing Labels, press the "Setup" button
in section 1 of the MailMerge helper dialog. Hit "OK".
Label Options: Product number 5160. Hit "OK".
This brings me to the Word Doc.
Hit Edit Recipient List on the ribbon. It brings up the correct list from
my category!!!
Hit "OK"
Then the Word Doc has a blank box in the upper left box (1st label). The
remaining 29 boxes contain the words "NextRecord".
Click on "Address Block" in the ribbon of the Word Doc. It shows the
correct name and format for the 1st individual in my category list!
Hit "OK".
Brings me back to the Word Doc, and the upper left label has the words
"AddressBlock" in it. The remaining 29 labels have "NextRecord". How do I
get the Contacts to populate in the 30 labels of the Word doc? ...
Show full article (3.92Kb)
no comments
Re: Using Contacts Category as list for printing labels         


Author: Leslie
Date: Aug 30, 2008 18:37

And, when I do a "print preview", the screen only shows the one name in the
box #1; all other 29 are blank. Can you help?
Thanks,
--
Leslie

"Leslie" wrote:
> Judy,
> When I preview results, I can individually see each recipient in the upper
> left box (label#1). The other 29 boxes are blank. I can hit the forward and
> backward arrows to see each individual...
Show full article (5.98Kb)
no comments
Re: Using Contacts Category as list for printing labels         


Author: Russ Valentine [MVP-Outlook]
Date: Aug 31, 2008 04:00

Did you forget to propagate the labels? It is a required and well documented
step when using a mail merge to create labels.
http://support.microsoft.com/?kbid=284401
--
Russ Valentine
[MVP-Outlook]
"Leslie" discussions.microsoft.com> wrote in message
news:E3F6FC73-7C53-4DB0-A87E-52BC5BA31E01@microsoft.com...
> And, when I do a "print preview", the screen only shows the one name in
> the
> box #1; all other 29 are blank. Can you help?
> Thanks,
> --
> Leslie
>
>
> "Leslie" wrote:
>
>> Judy,
>> When I preview results, I can individually see each recipient in the ...
Show full article (6.69Kb)
no comments
1 2