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 / June 2007

Tip: Looking for answers? Try searching our database.

Merging Multiple Records in One Document

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Microsoft Newsserver - 21 Jun 2007 15:10 GMT
Hi,

I'm trying to replicate something similar to an invoice in a Word document
via a mail merge. I'm selecting Directory as the document type and have a
datasource with several records of line items.

I would like to have some details appear only at the top (e.g. the person
who is receving the invoice and their address which are merge fields, along
with some static text) and then have the line items below that. The number
of line items can vary from invoice to invoice. I've got a basic example
working ok with the line items when I merge to a new document but I can't
get it to just show the address block information (merge fields with some
static text) only at the top and not repeated with every line item. For
example I would like it to look something like this:

Invoice # 123

To:
John Smith
123 Smith St
Smithville

Date Descriptoin Price

1/6/2007    widgets    45.00
15/6/2007    banananas    55.00

Total 100.00

Does anyone know if this is possible in word via the mail merge and what
steps I might be missing to accomplish this?

Many thanks,
Andrew
Peter Jamieson - 21 Jun 2007 15:17 GMT
Word isn't very good at this (do it as an Access report if you can)  but see
the "Group Multiple items for a single
condition" section on Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

or

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

Peter Jamieson

> Hi,
>
[quoted text clipped - 30 lines]
> Many thanks,
> Andrew
 
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.