mailing labels from a distribution list in Outlook 2007?

[MarcoPolo]

I need to send brochures to some of my contacts. Is there a quick way to
export snail mail addresses for avery labels from OL 2007?

 

[dlw]

File / Import and Export... etc.

 

[MarcoPolo]

That won't work. I get all my contacts listed in a CSV format. I can run a
mail merge from that, but then I still have to sort through and find the
contacts that I need to send mail to. eliminate the ones I don't want and am
forecd to doouble check the columns. I can do a map fields, but why? I still
need to go back through every line item....

I was hoping someone would've figured out that the mailing address field in
Outlook is goof for something like making a mailing list of specific contacts.

 

[Brian Tillman]

I need to send brochures to some of my contacts. Is there a quick way
to export snail mail addresses for avery labels from OL 2007?

Click Help and look for "mail merge"

 

[Russ Valentine [MVP-Outlook]]

Why would you need to export anything if your data is in Outlook? Read the
Help files or the many posts we have here on how to do a Mail Merge.

 

[MarcoPolo]

Gosh, I'm not real slow, but I guess I'm not real quick either. I tried as
you requested, help from word 2007 and help from Outlook 2007. I never did
get the labels I needed. I went to the website that was listed on how to do
the labels from word 2007 as was pointed out on one of your other posts about
mail merge. Now the frustration is really beginning to set in. I should've
just hand written everything, it would be much faster. I get through the
wizards, then Word says I have 3 pages of labels. But nothing shows. I've
gone through the Outlook contacts multiple times to pick out my 30 - 40
cxontacts needing the mailing. But the button at the top that selects all the
contacts is much to close to the top line, I hit that one accidentelly and
had to start all over. I guess this is the PIA portion of learning the new
2007 (or any new) system. Why must we populate the labels with fields? Why,
if Outlook knows the mailing address, and this is a mail merge, does it not
identify this set of fields and populate them automatically? Same as
addressing a single letter or envelope? Now I see another post pointing out I
need propogate the labels? Huh? I've worked with most of the previous Outlook
versions and never saw that one.

Won't this just be a bit simpler to export everything to csv file, convert
ot excel, eliminate all the other 876 contacts from my new 'database' and
then convert to word and outline them with the avery label format?

Aauurrrgh!!!!

 

[Russ Valentine [MVP-Outlook]]

I've used the instructions here with no problem at all:
http://www.gmayor.com/merge_labels_with_word_2007.htm