Group:  Microsoft Word » microsoft.public.word.mailmerge.fields
Thread: Hidden merge fields not showing up

Geek News

Hidden merge fields not showing up
"Brian Beck" <brian.beck[ at ]tea.state.tx.us> 5/31/2007 5:42:35 PM
I'm generating correspondence in Word 2003 using a template that grabs data
from an Access database. The letter will be addressed to a superintendent,
but a copy of the letter will also be sent to a district coordinator. It is
easy enough to print an envelope for the superintendent, but sometimes the
district coordinator has a different address then the superintendent, so I
was wanting to also have the district coordinator's address show up in the
letter, only I would make that text hidden and thus it would never print out
in the letter...however, when viewing the letter in Word, I could easily
highlight the district coordinator's address and print an envelope for them.

The problem I'm having is that when I make the merge fields hidden in the
template, the first set of the fields simply don't show up in the created
letter. The template looks like this (they are in a table with 2 columns and
1 row):

«SuperintendentFirstName» «SuperintendentMiddleName»
«SuperintendentLastName» «SuperintendentGenerational», «SuperintendentTitle»

«DistrictName»

«SuperintendentAddress»

«SuperintendentCity», Texas «SuperintendentZipCode»
«DTCFirstName» «DTCMiddleName» «DTCLastName» «DTCGenerational»,
District Testing Coordinator

«DistrictName»

«DTCAddress»

«DTCCity», Texas «DTCZipCode»



Everything in the right column is marked as hidden, but when I perform the
merge, this section:

«DTCFirstName» «DTCMiddleName» «DTCLastName» «DTCGenerational», District
Testing Coordinator



never shows up in the letter...it simply starts out by printing the
DistrictName and proceeds from there.



When I remove the hidden property in the template, everything shows up just
fine in the letter.



Any ideas on how to make this stuff show up in the letter?



-Brian


Re: Hidden merge fields not showing up
"Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 6/1/2007 5:02:38 AM
I wouldn't even try to do it this way. Create a separate merge for the
district coordinator envelopes using a SKIPIF field at the start of the
merge document to SKIP if the addresses are the same, if that is what you
require.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Brian Beck wrote:
[Quoted Text]
> I'm generating correspondence in Word 2003 using a template that
> grabs data from an Access database. The letter will be addressed to
> a superintendent, but a copy of the letter will also be sent to a
> district coordinator. It is easy enough to print an envelope for the
> superintendent, but sometimes the district coordinator has a
> different address then the superintendent, so I was wanting to also
> have the district coordinator's address show up in the letter, only I
> would make that text hidden and thus it would never print out in the
> letter...however, when viewing the letter in Word, I could easily
> highlight the district coordinator's address and print an envelope
> for them.
> The problem I'm having is that when I make the merge fields hidden in
> the template, the first set of the fields simply don't show up in the
> created letter. The template looks like this (they are in a table
> with 2 columns and 1 row):
>
> «SuperintendentFirstName» «SuperintendentMiddleName»
> «SuperintendentLastName» «SuperintendentGenerational»,
> «SuperintendentTitle»
> «DistrictName»
>
> «SuperintendentAddress»
>
> «SuperintendentCity», Texas «SuperintendentZipCode»
> «DTCFirstName» «DTCMiddleName» «DTCLastName» «DTCGenerational»,
> District Testing Coordinator
>
> «DistrictName»
>
> «DTCAddress»
>
> «DTCCity», Texas «DTCZipCode»
>
>
>
> Everything in the right column is marked as hidden, but when I
> perform the merge, this section:
>
> «DTCFirstName» «DTCMiddleName» «DTCLastName» «DTCGenerational»,
> District Testing Coordinator
>
>
>
> never shows up in the letter...it simply starts out by printing the
> DistrictName and proceeds from there.
>
>
>
> When I remove the hidden property in the template, everything shows
> up just fine in the letter.
>
>
>
> Any ideas on how to make this stuff show up in the letter?
>
>
>
> -Brian


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net