l.j

Resources, Articles and Information for Administrative Assistants, Executive Assistants, Virtual Assistants and Administrative  Professionals of all types.

 AdminProf.com has merged with DeskDemon.com, please visit:

http://www.DeskDemon.com for the lastest information.


 
       
  Administrative Assistants and Virtual Assistants  AdminProf.com Homepage

  Administrative Assistants and Virtual Assistants  Search 

  Administrative Assistants and Virtual Assistants  Admin Resources

  Administrative Assistants and Virtual Assistants  Meeting/ Event Planning
  Administrative Assistants and Virtual Assistants  Career Planning 
  How To Find A Job
  Administrative Assistants and Virtual Assistants  How To..... 
  Administrative Assistants and Virtual Assistants  Virtual Assistants
  List your VA business
  VA Listing
  VA Resources
  Administrative Assistants and Virtual Assistants  Templates
  Administrative Assistants and Virtual Assistants  Clip/Photo Art
  Administrative Assistants and Virtual Assistants  Certifications 
  Administrative Assistants and Virtual Assistants  Calendar of Events
  Administrative Assistants and Virtual Assistants  Dedicated Topic Areas
  The Male Admin 
  Working Mom
  Australian Admins
  Health Care Assistants
  Education Assistants
  Legal Assistants
  Administrative Assistants and Virtual Assistants  Seminars & Conferences
  Administrative Assistants and Virtual Assistants  Travel
  US
  UK
  Australia
  Administrative Assistants and Virtual Assistants  Training and Tips
  Tutorials
  Administrative Assistants and Virtual Assistants  Regional Resources
  US
  Australia
  Administrative Assistants and Virtual Assistants  Message Boards
  Administrative Assistants and Virtual Assistants  Changing Technology
  Virus Alert - Worldwide
  Administrative Assistants and Virtual Assistants  Professional Associations
  Administrative Assistants and Virtual Assistants  Articles/Archives/Newsletters
  Current Newsletter
  Administrative Assistants and Virtual Assistants  Coffee Break Time
  Administrative Assistants and Virtual Assistants  Admin Bookstore 
  Administrative Assistants and Virtual Assistants  Office/Computer Supplies
  Administrative Assistants and Virtual Assistants  Portal to Shopping.
  Administrative Assistants and Virtual Assistants  Admin Ecards
  Administrative Assistants and Virtual Assistants  Submit Feedback/Interact
  Administrative Assistants and Virtual Assistants  Links
  Administrative Assistants and Virtual Assistants  Support AdminProf.com

Line for Administrative Assistants and Virtual Assistants website

Mail Merge 

Sent in by Karen Bellows Page, CPS 

Mail merge - basic ideas. 

Create in excel the source information, use comprehensive headers, set the print range for your data area. Save this document where you can find it again. 

Create your target document in Word. Click on Tools Mail Merge. 
First button select what you are going to create (labels, letter etc.). 

Second button - get data source - click to open data source (the excel document will open in the background) a pop up should ask you for print area or entire document - chose print area. 

Now you are ready to insert Merge Fields. Under your tool bar at the top will be "Insert merge field" icon. 

Click and drop down should have your headers from the excel spreadsheet (such as name or address). 

Add fields in the appropriate area of the document. Remember to put spaces and commas (such as between city and state). 

Now click tools, mail merge and click the third button merge and click merge again. A new "merged" document will be created so if all doesn't look perfect go to Window and select the source document and made edits and "re-merge". 

It seems complicated but once you get through two or three merges you will be a pro. Try a simple address label first (when doing labels be sure to format for the appropriate label number)
Good Luck.


 

 

 

 

 

Home | Site Index | About Us | Contact Info/Disclaimer | Link to Us | Advertising | In the Media | Page of Thanks | Awards

 

Copyright © 2004 AdminProf.com and its licensors. All rights reserved.
Information in this document is subject to change without notice.
Other products and companies referred to herein are trademarks or registered trademarks of their respective companies or mark holders.