Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / July 2006

Tip: Looking for answers? Try searching our database.

address book from excel?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CBHoelzel - 22 Jul 2006 19:45 GMT
I have an Excel spreadsheet with names, addresses, etc. and wish to use  
MailMerge (or something) to put them in a two column format so I can print it
as needed.  So far I have gotten to a template set up as I wish, but when I
tell it to do a merge I get one full page of  the first entry, one full page
of the second entry, and so on, ad infinitum.  What step have I missed?

Chuck
Doug Robbins - Word MVP - 22 Jul 2006 22:13 GMT
Use a catalog, or in Word XP and later it is called a directory, type
mailmerge main document in which you have only a one row table, in the cells
of which you insert the merge fields.  When you execute such a merge to a
new document, that document will contain a table with a row of data for each
record in the datasource.

If you mean that you want the data arranged in two columns, format the main
document to have two columns and setup the table in the first column.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have an Excel spreadsheet with names, addresses, etc. and wish to use
> MailMerge (or something) to put them in a two column format so I can print
[quoted text clipped - 6 lines]
>
> Chuck
 
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.