Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Ol
 
Posts: n/a
Default Repeating text label in mailmerge

Hi

I've got the following formula :-

Students: (normal text label)
{MERGEFIELD TableStartStudent \* MERGEFORMAT } { MERGEFIELD Student_Number
\* MERGGEFORMAT} {MERGEFIELD Student_Name \* MERGEFORMAT } { MERGEFIELD
TableEndStudent \* MERGEFORMAT}

However, when the mail merge is run, the result is that it keeps repeating
the 'Student' text label - example below.

Students: 111 John Smith
Students: 222 Paul Frank
Students: 333 Dave Snow

How can i get it to only show the label once?

i.e.
Students: 111 John Smith
222 Paul Frank
333 Dave Snow

Any help greatly appreciated.

Ol


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Repeating text label in mailmerge

I am not sure what the "TableStartStudent" and "TableEndStudent" mergefields
contain/are supposed to do, but I assume that you are using a catalog or
directory type mail merge main document. That being the case, the only way
to get the Students: to appear once will be if you insert it into the
document that is created as a result of executing the merge.

--
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

"Ol" wrote in message
...
Hi

I've got the following formula :-

Students: (normal text label)
{MERGEFIELD TableStartStudent \* MERGEFORMAT } { MERGEFIELD Student_Number
\* MERGGEFORMAT} {MERGEFIELD Student_Name \* MERGEFORMAT } { MERGEFIELD
TableEndStudent \* MERGEFORMAT}

However, when the mail merge is run, the result is that it keeps repeating
the 'Student' text label - example below.

Students: 111 John Smith
Students: 222 Paul Frank
Students: 333 Dave Snow

How can i get it to only show the label once?

i.e.
Students: 111 John Smith
222 Paul Frank
333 Dave Snow

Any help greatly appreciated.

Ol




  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Ol
 
Posts: n/a
Default Repeating text label in mailmerge

Thanks for this.

Is there any web based resource for mailmerge formulae, in terms of correct
syntax layout, and explainations on what each property does ? just can't seem
to find any help online in terms of resource bases..

olly

"Doug Robbins - Word MVP" wrote:

I am not sure what the "TableStartStudent" and "TableEndStudent" mergefields
contain/are supposed to do, but I assume that you are using a catalog or
directory type mail merge main document. That being the case, the only way
to get the Students: to appear once will be if you insert it into the
document that is created as a result of executing the merge.

--
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

"Ol" wrote in message
...
Hi

I've got the following formula :-

Students: (normal text label)
{MERGEFIELD TableStartStudent \* MERGEFORMAT } { MERGEFIELD Student_Number
\* MERGGEFORMAT} {MERGEFIELD Student_Name \* MERGEFORMAT } { MERGEFIELD
TableEndStudent \* MERGEFORMAT}

However, when the mail merge is run, the result is that it keeps repeating
the 'Student' text label - example below.

Students: 111 John Smith
Students: 222 Paul Frank
Students: 333 Dave Snow

How can i get it to only show the label once?

i.e.
Students: 111 John Smith
222 Paul Frank
333 Dave Snow

Any help greatly appreciated.

Ol





  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Repeating text label in mailmerge

I am not sure exactly what you mean by mailmerge formulae and properties,
but take a look at some of the pages on fellow MVP Graham Mayor's website
at:

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm



--
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

"Ol" wrote in message
...
Thanks for this.

Is there any web based resource for mailmerge formulae, in terms of
correct
syntax layout, and explainations on what each property does ? just can't
seem
to find any help online in terms of resource bases..

olly

"Doug Robbins - Word MVP" wrote:

I am not sure what the "TableStartStudent" and "TableEndStudent"
mergefields
contain/are supposed to do, but I assume that you are using a catalog or
directory type mail merge main document. That being the case, the only
way
to get the Students: to appear once will be if you insert it into the
document that is created as a result of executing the merge.

--
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

"Ol" wrote in message
...
Hi

I've got the following formula :-

Students: (normal text label)
{MERGEFIELD TableStartStudent \* MERGEFORMAT } { MERGEFIELD
Student_Number
\* MERGGEFORMAT} {MERGEFIELD Student_Name \* MERGEFORMAT } { MERGEFIELD
TableEndStudent \* MERGEFORMAT}

However, when the mail merge is run, the result is that it keeps
repeating
the 'Student' text label - example below.

Students: 111 John Smith
Students: 222 Paul Frank
Students: 333 Dave Snow

How can i get it to only show the label once?

i.e.
Students: 111 John Smith
222 Paul Frank
333 Dave Snow

Any help greatly appreciated.

Ol







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
Header with picture or text box Scott Page Layout 15 April 28th 23 02:52 AM
Open word in text mode Jay Douglas Microsoft Word Help 9 February 15th 06 08:30 AM
Wandering text box Jim K Microsoft Word Help 7 December 23rd 05 11:27 PM
How to select paragraph between tow specified words? ALIOX Microsoft Word Help 1 June 28th 05 08:56 AM
How can I split justify text on the same line in a label. Kathy Richardson Page Layout 1 February 17th 05 11:53 PM


All times are GMT +1. The time now is 11:14 AM.

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

About Us

"It's about Microsoft Word"