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 / January 2006

Tip: Looking for answers? Try searching our database.

Producing tables with Mailmerge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andy Chan - 20 Jan 2006 16:20 GMT
Dear all,

   I want to use the mailmerge function to produce hundreds of forms from
an Excel file. The Excel file contains some sales data like this:

Purchaser Item Price
Amy Table 100
Amy Chair 50
Amy Desk 80
Betty Chair 60
Betty Sofa 120
Carl Sofa 100
Carl Desk 70
Carl Table 100
Carl Mat 50

The table is sorted by the column "Purchaser". Can I use the mailmerge
function to produce forms like this:

Purchaser: Amy
Item    Price
Table    100
Chair    50
Desk    80

etc...

One page contains only one form where the form contains all purchase of a
purchaser.

Besides, can the form be tabulated?

Best Regards,
Andy
Cindy M  -WordMVP- - 20 Jan 2006 17:37 GMT
Hi Andy,

I think you'll find exactly what you need in the DATABASE sample file
discussed in the "one-to-many" topic in the Special Merges section of my
website's mail merge FAQ.

> I want to use the mailmerge function to produce hundreds of forms from
> an Excel file. The Excel file contains some sales data like this:
[quoted text clipped - 25 lines]
>  
> Besides, can the form be tabulated?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
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.