Alphabetizing a mailing list

Discuss the word processor
Post Reply
sueok
Posts: 2
Joined: Tue Nov 27, 2018 9:37 pm

Alphabetizing a mailing list

Post by sueok »

I understand how to alphabetize a list, but I want to alphabetize a mailing list by addressee. Nothing I've tried so far has worked. I suspect it has something to do with the sort function, but maybe not. Can someone help?

Thanks
User avatar
RoryOF
Moderator
Posts: 35059
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Alphabetizing a mailing list

Post by RoryOF »

Is this an actual list in your document, or is it in a spreadsheet or database, used to produce mailmerge labels?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.5 LTS
sueok
Posts: 2
Joined: Tue Nov 27, 2018 9:37 pm

Re: Alphabetizing a mailing list

Post by sueok »

It's an actual list in my document.
OpenOffice 4.1.5 on Windows 7
John_Ha
Volunteer
Posts: 9596
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Alphabetizing a mailing list

Post by John_Ha »

1. Highlight the text
2. Tools > Sort

Use the options to sort on the correct item - you may need to edit the list to line up the columns.
Clipboard01.gif
It is almost certainly better to store an address list in a spreadsheet as you can then have a separate column for surname making sorting easy. Bring the names and addresses into a Writer document using Mail Merge - see Chapter 11 - Using Mail Merge in the Writer User Guide or search the forum for countless posts.
My Christmas card list spreadsheet - it has a split window so I can bring the Surname column to the left when I need to
My Christmas card list spreadsheet - it has a split window so I can bring the Surname column to the left when I need to
As a new poster you will find much useful information in the Writer FAQ, the Writer Tutorials, the up to date Writer guide and the Writer Manual. May I suggest you bookmark the pages.

Press F1 to access the Help screen and search for your problem

The chapter headings in the manual are:

1 - Introducing Writer
2 - Setting up Writer
3 - Working with Text
4 - Formatting Pages
5 - Printing, Exporting, Faxing and E-Mailing
6 - Introduction to Styles
7 - Working with Styles
8 - Working with Graphics
9 - Working with Tables
10 - Working with Templates
11 - Using Mail Merge
12 - Tables of Contents, Indexes and Bibliographies
13 - Working with Master Documents
14 - Working with Fields
15 - Using Forms in Writer
16 - Customizing Writer – Keyboard shortcuts.

When a pop-up window opens, click the Help button for extensive help on that function - it is often more comprehensive than the manual.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Post Reply