basic help: how to sort a mail merge address list

%3CLINGO-SUB%20id%3D%22lingo-sub-1578433%22%20slang%3D%22en-US%22%3Ebasic%20help%3A%20how%20to%20sort%20a%20mail%20merge%20address%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1578433%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20we%20are%20working%20on%20sending%20out%20letters%20and%20have%20a%20mailmerge%20list%20of%20names%20and%20addresses.%26nbsp%3B%20every%20piece%20of%20data%20is%20int%20a%20separate%20column%20on%20the%20same%20row.%26nbsp%3B%20how%20do%20we%20sort%20the%20list%20alphabetically%20by%20last%20name%20and%20keep%20all%20the%20other%20column%20values%20associated%20with%20that%20name%20in%20the%20same%20order.%26nbsp%3B%20Some%20last%20names%20are%20duplicate...but%20the%20first%20names%20differ%20as%20do%20the%20addresses.%26nbsp%3B%20we%20really%20need%20to%20keep%20all%20our%20rows%20intact.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20sure%20this%20is%20a%20very%20simple%20solution...but%20we%20are%20not%20tech%20people%20in%20our%20non%20profit%20org.%26nbsp%3B%20thanks%20for%20any%20assistance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1578433%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1578480%22%20slang%3D%22en-US%22%3ERe%3A%20basic%20help%3A%20how%20to%20sort%20a%20mail%20merge%20address%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1578480%22%20slang%3D%22en-US%22%3Ehighlight%20the%20cells%20with%20data%3CBR%20%2F%3EData%20Menu%3CBR%20%2F%3ESort%3CBR%20%2F%3Eif%20you%20have%20headers%20tick%20the%20box%20and%20the%20drop%20downs%20will%20show%20the%20information%20from%20the%20top%20row%2C%20if%20not%20then%20don't%20tick%20and%20you%20just%20tell%20it%20which%20column%20to%20sort%20by%3CBR%20%2F%3EIf%20you%20want%20to%20do%20Surname%20and%20then%201st%20name%20then%20you%20can%20add%20a%20level%2C%20top%20one%20surname%2C%202nd%20row%20should%20be%201st%20name%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1578517%22%20slang%3D%22de-DE%22%3ESubject%3A%20basic%20help%3A%20how%20to%20sort%20a%20mail%20merge%20address%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1578517%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F754829%22%20target%3D%22_blank%22%3E%40Roselle1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHello%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EThe%20example%20you%20mentioned%20and%20as%20I%20understand%20it%20should%20not%20only%20be%20better%20created%20with%20a%20database%20instead%20of%20Excel%2C%20but%20it%20is%20actually%20an%20access%20solution.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3EExcel%20has%20the%20advantage%20that%20it%20is%20used%20by%20many%20and%20can%20quickly%20create%20simple%20tables.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EAs%20soon%20as%20you%20need%20look-up%20values%20(activities%20for%20this%20customer%2C%20insert%20telephone%2C%20etc.)%2C%20you%20should%20switch%20from%20Excel%20to%20Access%20as%20a%20matter%20of%20urgency.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EFor%20this%20you%20need%20a%20real%20database%20with%201%3A%20n%20relationships%20and%20better%20form%20capabilities.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3EThere%20may%20be%20ShareWare%20solutions%20that%20already%20meet%20your%20needs%2C%20but%20the%20more%20extensive%20your%20requirements%2C%20the%20safer%20there%20is%20a%20lot%20of%20work%20(and%20therefore)%20involved.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%3EUnless%20someone%20here%20has%20already%20made%20a%20solution%20in%20this%20direction%20that%20he%20would%20like%20to%20share.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3ENikolino%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20know%20that%20I%20don't%20know%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi we are working on sending out letters and have a mailmerge list of names and addresses.  every piece of data is int a separate column on the same row.  how do we sort the list alphabetically by last name and keep all the other column values associated with that name in the same order.  Some last names are duplicate...but the first names differ as do the addresses.  we really need to keep all our rows intact.

 

I'm sure this is a very simple solution...but we are not tech people in our non profit org.  thanks for any assistance

2 Replies
highlight the cells with data
Data Menu
Sort
if you have headers tick the box and the drop downs will show the information from the top row, if not then don't tick and you just tell it which column to sort by
If you want to do Surname and then 1st name then you can add a level, top one surname, 2nd row should be 1st name

@Roselle1 

Hello,
The example you mentioned and as I understand it should not only be better created with a database instead of Excel, but it is actually an Access solution.

Excel has the advantage that it is used by many and can quickly create simple tables. As soon as you need look-up values (activities for this customer, insert telephone, etc.), you should switch from Excel to Access as a matter of urgency. For this you need a real database with 1: n relationships and better form capabilities.

There may be ShareWare solutions that already meet your needs, but the more extensive your requirements, the safer there is a lot of work (and therefore costs) involved.

Unless someone here has already made a solution in this direction that he would like to share.



Nikolino
I know that I don't know (Socrates)