 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2004Address labels list
Where do i start to look for making an address label list Will this list be used for Mail Merges? If so: http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm These are good places to get information. tj > Where do i start to look for making an address label list Good place to start AND finish! http://www.mvps.org/dmcritchie/excel/mailmerg.htm  SignatureHTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== Where do i start to look for making an address label list From the point of view of someone charged with supporting and trouble shooting approximately 125 mail mergers, I would caution you to add one feature that is often neglected by Excel experts, normalize your data as much as possible. Break it up into first name, last name , several address fields as well as separate city, stat and zip fields. This will allow far more flexibility in sorting and filtering if required, although if you are using Offec 2002 or later, you will be able to filter from the recipients list in the word mail merge wizard, or toolbar. Normalizing may save you future headaches that will require more sophisiticated parsing. You never know what the future of you data requirments and uses will require. > Where do i start to look for making an address label list PA I would disagree with your statement "often neglected by Excel experts". Setting up proper fields and names is foremost in most Excel experts instructions for mailmerge. See these two sites for example........... http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm Gord Dibben Excel MVP >From the point of view of someone charged with supporting and trouble >shooting approximately 125 mail mergers, I would caution you to add one [quoted text clipped - 9 lines] > >> Where do i start to look for making an address label list With all due respect, I must disagree with you. The example of a data source at http://www.mvps.org/dmcritchie/excel/mailmerg.htm is not normalized. Even the Mail Merge Wizard in MS Word leads the user to a more normalized set of fields. The example you cite combines frist and last name and also combines city, state and zip. The heavy mailmerge user needs much flexibility in sorting, by last name, or city or state or someother field. They are also mainly Word users and not power users of Excel. While sorting by State in a field of combined City, State, Zip data would be easy for you (even I can do it). an administrative assistant, under the gun to get out 800 form letters does not have time to learn. For further clarification on this and other MailMerge issues, you should refer to microsoft.public.word.mailmerge > PA > [quoted text clipped - 24 lines] > > > >> Where do i start to look for making an address label list PA You are correct in your summation of the material presented at David's site. I did not look closely enough. He does combine some fields as you point out. Please accept apologies and thanks for your observations on this subject. Gord >With all due respect, I must disagree with you. The example of a data source >at [quoted text clipped - 40 lines] >> > >> >> Where do i start to look for making an address label list |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.