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

Tip: Looking for answers? Try searching our database.

Mail Merge to Create  a List Sorted by Category

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dhoward - 30 Mar 2006 19:06 GMT
I found this link in a posting from March 28 titled "Limit data merging into
Word Doc"  http://support.microsoft.com/default.aspx?scid=kb;en-us;211303.  I
was able to merge my data sorted by category.  But I can't figure out how to
use this merge to create a table.  I've pasted the merge below.  The third
line to the second appearance of MERGEFIELD Sales is all in the same bracket,
I haven't been able to use this merge routine in a table.  Any ideas?

{ IF { MERGESEQ } = "1" "{ MERGEFIELD City }" "" }<ENTER>
{ SET Place1 { MERGEFIELD City }}<ENTER>
{ If { Place2 } <> { Place1 }"<ENTER>
{ MERGEFIELD City }<ENTER>
<ENTER>
{ MERGEFIELD Employee }{ MERGEFIELD Sales }" "{ MERGEFIELD Employee }{
MERGEFIELD Sales }" }{ SET Place2 { MERGEFIELD City }}<ENTER>
Peter Jamieson - 30 Mar 2006 19:57 GMT
Do you mean that the method does not even produce the list you expect even
if you do not try to put the putput into a table? If so, are you sure that
all the {} are field braces, i.e. the sort you can enter using ctrl-F9.

Or do you mean that the example works in the sense that you can get the
correct list of data, but fails when you try to format that list as a table?
If so, that is normal, and not easy to solve using this method - you may
need to use the DATABASE field approach described on Cindy Meister's pages
at

http://homepage.swissonline.ch/cindymeister/

- see Mailmerge FAQ, Special Merges, Multiple Items per condition.

However, Word has many limitations in this area and you may be better off
producing this kind of report using something like the report generator in
Access (especially if your data is already held in that package!)

Peter Jamieson

>I found this link in a posting from March 28 titled "Limit data merging
>into
[quoted text clipped - 14 lines]
> { MERGEFIELD Employee }{ MERGEFIELD Sales }" "{ MERGEFIELD Employee }{
> MERGEFIELD Sales }" }{ SET Place2 { MERGEFIELD City }}<ENTER>
dhoward - 06 Apr 2006 20:47 GMT
Thanks for your posting.  I did mean your second question.   I will study her
suggestions and see if I can figure out how to implement.  

>Do you mean that the method does not even produce the list you expect even
>if you do not try to put the putput into a table? If so, are you sure that
[quoted text clipped - 21 lines]
>> { MERGEFIELD Employee }{ MERGEFIELD Sales }" "{ MERGEFIELD Employee }{
>> MERGEFIELD Sales }" }{ SET Place2 { MERGEFIELD City }}<ENTER>
 
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.