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 / July 2004

Tip: Looking for answers? Try searching our database.

Table add cells IF

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
javier - 20 Jul 2004 19:01 GMT
I have a Word form, using an Excel database, where I am
listing people who's been with us for five years.
I set up a table with two columns:

Column A
{ IF {MERGEFIELD Anniv} = 5 "{ MERGEFIELD First_Name }
{MERGEFIELD Middle_Initial } {MERGEFIELD Last_Name }" "" }
Column B
{ NEXT }{ IF {MERGEFIELD Anniv} = 5 "{ MERGEFIELD
First_Name } {MERGEFIELD Middle_Initial } {MERGEFIELD
Last_Name }" "" }

Next rows/cells As and Bs should enter next qualifying
records from spreadsheet IF there are any more, otherwise
to END the table at last qualifying record:

How can I set up that table to insert AS MANY CELLS/ROWS
as THERE ARE QUALIFYING RECORDS, and print closing
text "Please send us appropriate appraisals for above
mentioned individuals"
right afterwards?
Peter Jamieson - 23 Jul 2004 11:00 GMT
Mailmerge is probably going to get in your way on this one, unless you
simplify the process a bit. e.g.:
a. create the letter as a non-mail merge document
b. set up a separate mail merge main document as a single table row (and
nothing else except the final paragraph mark, which you can't remove) with

Column A
{ MERGEFIELD First_Name } {MERGEFIELD Middle_Initial } {MERGEFIELD
Last_Name }
Column B
{ NEXT }{ MERGEFIELD First_Name } {MERGEFIELD Middle_Initial } {MERGEFIELD
Last_Name }

and use the Select recipients dialog box (or Merge Options, depending on the
version of Word) to specify Anniv = 5.

c. do the merge to an output document
d. use Edit Copy/Paste (or save the output document and use Insert|File) to
insert the output into the document you created in (a).

Or you could consider creating the Excel sheet you need and copying/pasting
it directly into the document you created in (a).

If you are producing one document for each of a number of recipients
automating that approach would probably be the simplest way to do this,
although there are alternatives.

Signature

Peter Jamieson

> I have a Word form, using an Excel database, where I am
> listing people who's been with us for five years.
[quoted text clipped - 17 lines]
> mentioned individuals"
> right afterwards?
 
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.