very basic label question gbafam(remove)[ at ]frontiernet.net 12/23/2008 6:02:01 PM I have a very simple question to which, apparently, there seems no simple answer. I have about 200 names in outlook categorized as "christmas list." All I want to do is print Avery 5160 (or something similar) labels with those addresses on labels. Apparently Word must be used for this (why, I don't know). But when I start working my way through mail merge to accomplish this, I get to the "contacts" option, but neither sort nor filter gives me labels or categories or whatever Word 2007 calls what used to be categories in 2003. No step by step directions could be found. I recognize this is neither a sophisticated nor difficult question for high powered users, but I don't understand why Word makes this such a challenging process. I'd settle at this point for direction to a site which gives step by step instructions for the Word challenged. Thanks.

Re: very basic label question "Suzanne S. Barnhill" <sbarnhill[ at ]mvps.org> 12/23/2008 6:10:27 PM See http://www.gmayor.com/mailmerge_from_outlook.htm and http://www.gmayor.com/merge_labels_with_word_2007.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "gbafam(remove)[ at ]frontiernet.net" <gbafamremovefrontiernetnet[ at ]discussions.microsoft.com> wrote in message news:2D19AD92-2295-48BF-B5AF-50613DB3E758[ at ]microsoft.com... [Quoted Text] >I have a very simple question to which, apparently, there seems no simple > answer. I have about 200 names in outlook categorized as "christmas > list." > All I want to do is print Avery 5160 (or something similar) labels with > those > addresses on labels. Apparently Word must be used for this (why, I don't > know). But when I start working my way through mail merge to accomplish > this, I get to the "contacts" option, but neither sort nor filter gives me > labels or categories or whatever Word 2007 calls what used to be > categories > in 2003. No step by step directions could be found. I recognize this is > neither a sophisticated nor difficult question for high powered users, but > I > don't understand why Word makes this such a challenging process. I'd > settle > at this point for direction to a site which gives step by step > instructions > for the Word challenged. Thanks. >

Re: very basic label question "Beth Melton" <bmelton[ at ]mvps.org> 12/24/2008 9:11:03 PM The easiest way to use a group of Contacts in the same category for mail merge is to follow these steps: - View your Contacts in Outlook by category - Click the Category heading above the group of Contacts (this will quickly select all in the group) - Click Tools/Mail Merge\ - In the Mail Merge Contacts dialog box select the option "Only selected contacts", change the Document Type at the bottom to "Mailing Labels", accept all other defaults, and then click OK. - After Word starts you'll be instructed to select your Label type by clicking the Setup button in the Mail Merge Helper. - Close the dialog box after selecting your Label. - On the Mailings tab use the Write & Insert Fields group to create your labels. For example use the Insert Merge Field button to insert the fields for the name and address. - Once you have the first label complete, click the Update Labels button to make the same change to the other labels. - Follow the rest of the merge process using the last two groups: Preview Results and then Finish. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP https://mvp.support.microsoft.com/profile/Melton What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs Guides for the Office 2007 Interface: http://office.microsoft.com/en-us/training/HA102295841033.aspx "gbafam(remove)[ at ]frontiernet.net" <gbafamremovefrontiernetnet[ at ]discussions.microsoft.com> wrote in message news:2D19AD92-2295-48BF-B5AF-50613DB3E758[ at ]microsoft.com... [Quoted Text] > I have a very simple question to which, apparently, there seems no simple > answer. I have about 200 names in outlook categorized as "christmas > list." > All I want to do is print Avery 5160 (or something similar) labels with > those > addresses on labels. Apparently Word must be used for this (why, I don't > know). But when I start working my way through mail merge to accomplish > this, I get to the "contacts" option, but neither sort nor filter gives me > labels or categories or whatever Word 2007 calls what used to be > categories > in 2003. No step by step directions could be found. I recognize this is > neither a sophisticated nor difficult question for high powered users, but > I > don't understand why Word makes this such a challenging process. I'd > settle > at this point for direction to a site which gives step by step > instructions > for the Word challenged. Thanks.

Re: very basic label question gbafam(remove)[ at ]frontiernet.net 12/26/2008 4:13:01 AM Thanks for this; I"m betting this will be very helpful. It's still surprising to me that this is so complicated. AGain, thanks. gba "Suzanne S. Barnhill" wrote: [Quoted Text] > See http://www.gmayor.com/mailmerge_from_outlook.htm and > http://www.gmayor.com/merge_labels_with_word_2007.htm > > -- > Suzanne S. Barnhill > Microsoft MVP (Word) > Words into Type > Fairhope, Alabama USA > http://word.mvps.org > > "gbafam(remove)[ at ]frontiernet.net" > <gbafamremovefrontiernetnet[ at ]discussions.microsoft.com> wrote in message > news:2D19AD92-2295-48BF-B5AF-50613DB3E758[ at ]microsoft.com... > >I have a very simple question to which, apparently, there seems no simple > > answer. I have about 200 names in outlook categorized as "christmas > > list." > > All I want to do is print Avery 5160 (or something similar) labels with > > those > > addresses on labels. Apparently Word must be used for this (why, I don't > > know). But when I start working my way through mail merge to accomplish > > this, I get to the "contacts" option, but neither sort nor filter gives me > > labels or categories or whatever Word 2007 calls what used to be > > categories > > in 2003. No step by step directions could be found. I recognize this is > > neither a sophisticated nor difficult question for high powered users, but > > I > > don't understand why Word makes this such a challenging process. I'd > > settle > > at this point for direction to a site which gives step by step > > instructions > > for the Word challenged. Thanks. > > > > >