How to arrange mailing labels alphabetically by last name?

  • Follow


Word 2007, arrange mailing labels alphabetically by last name?
0
Reply Utf 1/29/2010 10:15:01 PM

Use the instructions in 
http://www.word.mvps.org/FAQs/MailMerge/ConvertAdrsToDatafile.htm to convert 
the labels to a data source, sort it, and then re-merge the labels.

-- 
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"mazziossharon" <mazziossharon@discussions.microsoft.com> wrote in message 
news:D941ABB9-7BC4-49AC-8FF2-CB32F62A2FD9@microsoft.com...
> Word 2007, arrange mailing labels alphabetically by last name?
> 

0
Reply Suzanne 1/29/2010 11:48:23 PM


Before you run the merge go back to "edit the recipient list," click on 
"edit," next screen, click "Filter and Sort", then "Sort Records," then "Sort 
by," choose "last name," click okay and the merge will run alpha by last name.

Suzanne S. Barnhill" wrote:

> Use the instructions in 
> http://www.word.mvps.org/FAQs/MailMerge/ConvertAdrsToDatafile.htm to convert 
> the labels to a data source, sort it, and then re-merge the labels.
> 
> -- 
> Suzanne S. Barnhill
> Microsoft MVP (Word)
> Words into Type
> Fairhope, Alabama USA
> http://word.mvps.org
> 
> "mazziossharon" <mazziossharon@discussions.microsoft.com> wrote in message 
> news:D941ABB9-7BC4-49AC-8FF2-CB32F62A2FD9@microsoft.com...
> > Word 2007, arrange mailing labels alphabetically by last name?
> > 
> 
> .
> 
0
Reply Utf 1/30/2010 1:58:01 AM

That assumes the OP already has a "recipient list" (i.e., a data source).

-- 
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"marysully" <marysully@discussions.microsoft.com> wrote in message 
news:9ACC5E93-FA9A-4830-BA3A-C59B4B131816@microsoft.com...
> Before you run the merge go back to "edit the recipient list," click on
> "edit," next screen, click "Filter and Sort", then "Sort Records," then 
> "Sort
> by," choose "last name," click okay and the merge will run alpha by last 
> name.
>
> Suzanne S. Barnhill" wrote:
>
>> Use the instructions in
>> http://www.word.mvps.org/FAQs/MailMerge/ConvertAdrsToDatafile.htm to 
>> convert
>> the labels to a data source, sort it, and then re-merge the labels.
>>
>> -- 
>> Suzanne S. Barnhill
>> Microsoft MVP (Word)
>> Words into Type
>> Fairhope, Alabama USA
>> http://word.mvps.org
>>
>> "mazziossharon" <mazziossharon@discussions.microsoft.com> wrote in 
>> message
>> news:D941ABB9-7BC4-49AC-8FF2-CB32F62A2FD9@microsoft.com...
>> > Word 2007, arrange mailing labels alphabetically by last name?
>> >
>>
>> .
>>
> 

0
Reply Suzanne 1/30/2010 3:14:51 AM

3 Replies
1448 Views

(page loaded in 0.231 seconds)


Reply: