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

Tip: Looking for answers? Try searching our database.

Multiple excel lines on one letter on mail merge.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ahmed_sadak@yahoo.co.uk - 03 Oct 2007 12:14 GMT
Hi All,

My question is simple, probably has a simple answer.
I have a list of customers who us money, now, i have all their details
on excel so i did a mail merge but most customers owe more than one
invoice, how do i list boith invoices on one letter rather than mail
merge generating 2 letters for the same customer.
Peter Jamieson - 04 Oct 2007 09:14 GMT
> probably has a simple answer.

Unfortunately not...Word is not really designed to do this stuff.

If you have Access you may be better off importing your data to Access and
using its reporting facilities.

Using fields, you can try starting with the example in the following KB
article:

http://support.microsoft.com/kb/211303

There are other ways to do it (e.g. using a DATABASE field to pick up
multiple lines per customer, but that does have some problems, or generating
your Word document from scratch using Word or Excel VBA) but I'd see how you
get on with the approach described in the article.
Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Hi All,
>
[quoted text clipped - 3 lines]
> invoice, how do i list boith invoices on one letter rather than mail
> merge generating 2 letters for the same customer.
Doug Robbins - Word MVP - 04 Oct 2007 09:23 GMT
Sounds like you are trying to perform a "multiple items per condition (=key
field)" mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

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

Or take a look at the following Knowledge Base Article

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

or at:

http://cornell.veplan.net/article.aspx?&a=3815

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

> Hi All,
>
[quoted text clipped - 3 lines]
> invoice, how do i list boith invoices on one letter rather than mail
> merge generating 2 letters for the same customer.
 
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.