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

Tip: Looking for answers? Try searching our database.

complicated mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kkappabear - 24 Nov 2006 12:56 GMT
I am using mail merge to get data from excel to word. My problem is,
that i have variable excel source, in which I need to use several lines

into single word document, that means, not each new line should
automaticly be new 'mail' in word.
example:
ID       status         name        cash
1        D                aaa           111
1        D                bbb           222
1        I                 ccc            333
1        O               ddd             444
2         D               eee            555
2         O                fff              666
3         I                 ggg            777
in this document, i need new mail only for unique ID , and in this i
need to include into new page separately all lines with same status
so the word documents would look like
1) 1st document
1st page
D       aaa          111
D       bbb          222
2nd page
I         ccc          333
3rd page
O       ddd           444
2) - 2nd document
1st page
D       eee           555
2nd page
blank
3rd page
O       fff           666
3) - 3rd document
1st page
blank
2nd page
I         ggg            777
3rd page
blank..

i hope it's written good enough to understand.
so, is it possible to even create something like this using standard
tools, or absolutely not?, and if so, then how to create some kind of
cycle there (WHILE ID="" and STATUS="" get all lines)

(and please excuse my rather poor english, i'm not a native speaker:)
Doug Robbins - Word MVP - 24 Nov 2006 18:24 GMT
Sounds like you are probably 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

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

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 am using mail merge to get data from excel to word. My problem is,
> that i have variable excel source, in which I need to use several lines
[quoted text clipped - 42 lines]
>
> (and please excuse my rather poor english, i'm not a native speaker:)
 
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.