Reply
 
Thread Tools Display Modes
  #1   Report Post  
a
 
Posts: n/a
Default check current mailmerge field against previous

Hello,

is it possible to check a current mailmerge filed ("NextNo") against the
previous value? i have a table which lists all people associated to a
company. i know that the max number of people is 15. so i have a table with
15 rows which will display people associated to the current company. however
if there are only 2 people associated to a company the way then the last
person is duplicated 14 times!

in each row on the table i have a "next record if", i then need a "if then
else" statement which should be:

if current value of "nextno"= previous value of nextno then show nothing
else display "Tno"

Any help would be great

Cheers


  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi A,

is it possible to check a current mailmerge filed ("NextNo") against the
previous value? i have a table which lists all people associated to a
company. i know that the max number of people is 15. so i have a table with
15 rows which will display people associated to the current company. however
if there are only 2 people associated to a company the way then the last
person is duplicated 14 times!

The approach described in this KB article should do what you need:

HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2000
http://support.microsoft.com?kbid=211303

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

  #3   Report Post  
a
 
Posts: n/a
Default

thanks for the reply, that was very useful after i read through it a few
times

Cheers Cindy

Graham


"Cindy M -WordMVP-" wrote in message
news:VA.0000a9f0.006d4fb4@speedy...
Hi A,

is it possible to check a current mailmerge filed ("NextNo") against the
previous value? i have a table which lists all people associated to a
company. i know that the max number of people is 15. so i have a table
with
15 rows which will display people associated to the current company.
however
if there are only 2 people associated to a company the way then the last
person is duplicated 14 times!

The approach described in this KB article should do what you need:

HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2000
http://support.microsoft.com?kbid=211303

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply
in the newsgroup and not by e-mail :-)



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Putting an actual check mark in a check box form field. Margot Microsoft Word Help 2 February 21st 05 09:59 PM
Add code to select email field in mailmerge! Hans Mailmerge 4 February 3rd 05 06:47 AM
Check box field in a form Igor Microsoft Word Help 2 January 17th 05 11:52 PM
Getting Spell Check Macro to work Tom Hyland Microsoft Word Help 8 January 14th 05 06:45 PM
Fill-in field - returning to a previous field. Lorrie Mailmerge 1 December 13th 04 07:39 PM


All times are GMT +1. The time now is 05:53 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"