Mail merge combined with "frames"...

D

David Schrader

Hello all, hope this is the correct news group for this question...

The basics:

- I am using Office 2003 with all updates and bug-fixes.
- I send a monthly newsletter to 60-75 some-odd people.
- The list of names and addresses is stored in an Excel file
- I use mailmerge to print both the letter and the envelope
(and it works without any problems).

The problem and the need:

From time to time the envelope is returned with "Addressee
Unknown." The USPS people and they've said that this
usually happens when "forwarding" has expired. (By then
it's too late to request a forwarding address, all of the
information has been discarded.)

I'd like to print "Do not Forward. Address correction
requested." on the envelope (using a frame) from time to
time. I can easily add a field in the database to "toggle"
between displaying or not displaying the message. I do
not want to print it each month - just two or three times
a year.

My problem is that I haven't been able to find a way to
insert a word "Field" which can/will display or hide the
Word "frame" based upon the status of the Excel toggle
field. (Or, for that matter an "ASK" field or a bookmark.)

Question:

Can this be done and, if so, can someone provide a simple
example of how it would be done? Excel field preferred but
I'll take an ASK or bookmark too.

Many thanks in advance.

David
 
D

Doug Robbins - Word MVP

I would just add a column to the Excel Spreadsheet, into each row of which
you would copy the message and insert a corresponding mergefield on the
Envelope whenever you want the message to appear.

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

macropod

Hi David,

To conditionally insert something based on the presence of any content in a data field for a mailmerge, you can use an IF test,
coded along the lines of:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
where 'Toggle' is the name of your data field.

Alternatively, to conditionally insert something based on the presence of a specified content in a data field for a mailmerge, you
can use an IF test, coded along the lines of:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied"}
where 'Toggle' is the name of your data field and 'Condition' is the whatever is required to be present before the output is
displayed.

In both cases, you can even 'toggle' the text to be displayed. For example:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied" "Content to output if Toggle condition is NOT
satisfied"}

In each case, the 'output' can include text, shapes, pictures, other mergefields, etc.

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likwise, you can't type the chevrons (ie '« »') - they're part of the actual mergefields, which you can
insert from the mailmerge toolbar.
 
D

David Schrader

macropod,

First, thanks for your reply...

Please see my reply to Doug - much of it applies here.
You addressed a solution to my problem but didn't
elaborate of how to do it. (I've highlighted your
reference in red below.)

Unfortunately you didn't provide an example of *how*
to build the *IF* statement that will do what I need.
For example, you suggested:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
What I need is:
{IF«Toggle»<> "N" "Insert/Display Frame with text"}
or
{IF«Toggle»<> "N" "Insert/Display Image of border with text"}

It's that part which I haven't been able to find explained
somewhere.

David

macropod said:
Hi David,

To conditionally insert something based on the presence of any content in a data field for a mailmerge, you can use an IF test,
coded along the lines of:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
where 'Toggle' is the name of your data field.

Alternatively, to conditionally insert something based on the presence of a specified content in a data field for a mailmerge, you
can use an IF test, coded along the lines of:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied"}
where 'Toggle' is the name of your data field and 'Condition' is the whatever is required to be present before the output is
displayed.

In both cases, you can even 'toggle' the text to be displayed. For example:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied" "Content to output if Toggle condition is NOT
satisfied"}

In each case, the 'output' can include text, shapes, pictures, other mergefields, etc.

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likwise, you can't type the chevrons (ie '« »') - they're part of the actual mergefields, which you can
insert from the mailmerge toolbar.

--
Cheers
macropod
[MVP - Microsoft Word]


David Schrader said:
Hello all, hope this is the correct news group for this question...

The basics:

- I am using Office 2003 with all updates and bug-fixes.
- I send a monthly newsletter to 60-75 some-odd people.
- The list of names and addresses is stored in an Excel file
- I use mailmerge to print both the letter and the envelope
(and it works without any problems).

The problem and the need:

From time to time the envelope is returned with "Addressee
Unknown." The USPS people and they've said that this
usually happens when "forwarding" has expired. (By then
it's too late to request a forwarding address, all of the
information has been discarded.)

I'd like to print "Do not Forward. Address correction
requested." on the envelope (using a frame) from time to
time. I can easily add a field in the database to "toggle"
between displaying or not displaying the message. I do
not want to print it each month - just two or three times
a year.

My problem is that I haven't been able to find a way to
insert a word "Field" which can/will display or hide the
Word "frame" based upon the status of the Excel toggle
field. (Or, for that matter an "ASK" field or a bookmark.)

Question:

Can this be done and, if so, can someone provide a simple
example of how it would be done? Excel field preferred but
I'll take an ASK or bookmark too.

Many thanks in advance.

David
 
M

macropod

Hi David,

As previously posted, you can use an IF test coded along the lines of:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
where 'Toggle' is the name of your data field.

Here are some step-by-step instructions on how to create this on your envelope mailmerge main document:
1. Create and format the text with the encompassing frame in a pair of paragraphs preceding the first mergefield on your envelope. This should give you something laid out like:
Please Do NOT Forward¶
Address Correction Requested¶
«Addressee Name»¶

2. Select the two framed paragraphs, including both paragraph markers and press Ctrl-F9. This will enclose them in a pair of field braces, thus:
{ Please Do NOT Forward¶
Address Correction Requested¶
}«Addressee Name»¶

3. After the left-hand field brace, insert your 'toggle' field via the mailmerge toolbar, thus:
{«Toggle» Please Do NOT Forward¶
Address Correction Requested¶
}«Addressee Name»¶

4. Now fill in the rest of the field so that you end up with:
{IF«Toggle»<> "" "Please Do NOT Forward¶
Address Correction Requested¶
"}«Addressee Name»¶
deleting any extraneous spaces in the field. Note the positioning of the double quotes surrounding your message.

5. Run your mailmerge


--
Cheers
macropod
[MVP - Microsoft Word]


macropod,

First, thanks for your reply...

Please see my reply to Doug - much of it applies here.
You addressed a solution to my problem but didn't
elaborate of how to do it. (I've highlighted your
reference in red below.)

Unfortunately you didn't provide an example of *how*
to build the *IF* statement that will do what I need.
For example, you suggested:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
What I need is:
{IF«Toggle»<> "N" "Insert/Display Frame with text"}
or
{IF«Toggle»<> "N" "Insert/Display Image of border with text"}

It's that part which I haven't been able to find explained
somewhere.

David

macropod said:
Hi David,

To conditionally insert something based on the presence of any content in a data field for a mailmerge, you can use an IF test,
coded along the lines of:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
where 'Toggle' is the name of your data field.

Alternatively, to conditionally insert something based on the presence of a specified content in a data field for a mailmerge, you
can use an IF test, coded along the lines of:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied"}
where 'Toggle' is the name of your data field and 'Condition' is the whatever is required to be present before the output is
displayed.

In both cases, you can even 'toggle' the text to be displayed. For example:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied" "Content to output if Toggle condition is NOT
satisfied"}

In each case, the 'output' can include text, shapes, pictures, other mergefields, etc.

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likwise, you can't type the chevrons (ie '« »') - they're part of the actual mergefields, which you can
insert from the mailmerge toolbar.

--
Cheers
macropod
[MVP - Microsoft Word]


David Schrader said:
Hello all, hope this is the correct news group for this question...

The basics:

- I am using Office 2003 with all updates and bug-fixes.
- I send a monthly newsletter to 60-75 some-odd people.
- The list of names and addresses is stored in an Excel file
- I use mailmerge to print both the letter and the envelope
(and it works without any problems).

The problem and the need:

From time to time the envelope is returned with "Addressee
Unknown." The USPS people and they've said that this
usually happens when "forwarding" has expired. (By then
it's too late to request a forwarding address, all of the
information has been discarded.)

I'd like to print "Do not Forward. Address correction
requested." on the envelope (using a frame) from time to
time. I can easily add a field in the database to "toggle"
between displaying or not displaying the message. I do
not want to print it each month - just two or three times
a year.

My problem is that I haven't been able to find a way to
insert a word "Field" which can/will display or hide the
Word "frame" based upon the status of the Excel toggle
field. (Or, for that matter an "ASK" field or a bookmark.)

Question:

Can this be done and, if so, can someone provide a simple
example of how it would be done? Excel field preferred but
I'll take an ASK or bookmark too.

Many thanks in advance.

David
 
D

David Schrader

macropod,

Your reply is a bit *ponderous* and I'll have to work it
through step-by-step in order to make certain I under-
stand it clearly. I'll try to get to it this evening after work
and let you know how it goes.

Again, thanks.

David

Hi David,

As previously posted, you can use an IF test coded along the lines of:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
where 'Toggle' is the name of your data field.

Here are some step-by-step instructions on how to create this on your envelope mailmerge main document:
1. Create and format the text with the encompassing frame in a pair of paragraphs preceding the first mergefield on your envelope. This should give you something laid out like:
Please Do NOT Forward¶
Address Correction Requested¶
«Addressee Name»¶

2. Select the two framed paragraphs, including both paragraph markers and press Ctrl-F9. This will enclose them in a pair of field braces, thus:
{ Please Do NOT Forward¶
Address Correction Requested¶
}«Addressee Name»¶

3. After the left-hand field brace, insert your 'toggle' field via the mailmerge toolbar, thus:
{«Toggle» Please Do NOT Forward¶
Address Correction Requested¶
}«Addressee Name»¶

4. Now fill in the rest of the field so that you end up with:
{IF«Toggle»<> "" "Please Do NOT Forward¶
Address Correction Requested¶
"}«Addressee Name»¶
deleting any extraneous spaces in the field. Note the positioning of the double quotes surrounding your message.

5. Run your mailmerge


--
Cheers
macropod
[MVP - Microsoft Word]


macropod,

First, thanks for your reply...

Please see my reply to Doug - much of it applies here.
You addressed a solution to my problem but didn't
elaborate of how to do it. (I've highlighted your
reference in red below.)

Unfortunately you didn't provide an example of *how*
to build the *IF* statement that will do what I need.
For example, you suggested:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
What I need is:
{IF«Toggle»<> "N" "Insert/Display Frame with text"}
or
{IF«Toggle»<> "N" "Insert/Display Image of border with text"}

It's that part which I haven't been able to find explained
somewhere.

David

macropod said:
Hi David,

To conditionally insert something based on the presence of any content in a data field for a mailmerge, you can use an IF test,
coded along the lines of:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
where 'Toggle' is the name of your data field.

Alternatively, to conditionally insert something based on the presence of a specified content in a data field for a mailmerge, you
can use an IF test, coded along the lines of:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied"}
where 'Toggle' is the name of your data field and 'Condition' is the whatever is required to be present before the output is
displayed.

In both cases, you can even 'toggle' the text to be displayed. For example:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied" "Content to output if Toggle condition is NOT
satisfied"}

In each case, the 'output' can include text, shapes, pictures, other mergefields, etc.

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likwise, you can't type the chevrons (ie '« »') - they're part of the actual mergefields, which you can
insert from the mailmerge toolbar.

--
Cheers
macropod
[MVP - Microsoft Word]


David Schrader said:
Hello all, hope this is the correct news group for this question...

The basics:

- I am using Office 2003 with all updates and bug-fixes.
- I send a monthly newsletter to 60-75 some-odd people.
- The list of names and addresses is stored in an Excel file
- I use mailmerge to print both the letter and the envelope
(and it works without any problems).

The problem and the need:

From time to time the envelope is returned with "Addressee
Unknown." The USPS people and they've said that this
usually happens when "forwarding" has expired. (By then
it's too late to request a forwarding address, all of the
information has been discarded.)

I'd like to print "Do not Forward. Address correction
requested." on the envelope (using a frame) from time to
time. I can easily add a field in the database to "toggle"
between displaying or not displaying the message. I do
not want to print it each month - just two or three times
a year.

My problem is that I haven't been able to find a way to
insert a word "Field" which can/will display or hide the
Word "frame" based upon the status of the Excel toggle
field. (Or, for that matter an "ASK" field or a bookmark.)

Question:

Can this be done and, if so, can someone provide a simple
example of how it would be done? Excel field preferred but
I'll take an ASK or bookmark too.

Many thanks in advance.

David
 
D

David Schrader

macropod,

Sorry for the delay, the kids got a new version of
W_O_W and it took a while to get my turn.

I tried what you suggested. Some worked, some
didn't. I couldn't find a method of dropping a text
box (with out without text) into a IF-ELSE field.
The anchor.Cross didn't want to settle into the
field.

Using text alone seemed to work without any
problems but I'm still deprived of the having a
text "frame."

I'll play with it a while longer before I give up.
If I do finally get it working I'll report back here.

David

Hi David,

As previously posted, you can use an IF test coded along the lines of:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
where 'Toggle' is the name of your data field.

Here are some step-by-step instructions on how to create this on your envelope mailmerge main document:
1. Create and format the text with the encompassing frame in a pair of paragraphs preceding the first mergefield on your envelope. This should give you something laid out like:
Please Do NOT Forward¶
Address Correction Requested¶
«Addressee Name»¶

2. Select the two framed paragraphs, including both paragraph markers and press Ctrl-F9. This will enclose them in a pair of field braces, thus:
{ Please Do NOT Forward¶
Address Correction Requested¶
}«Addressee Name»¶

3. After the left-hand field brace, insert your 'toggle' field via the mailmerge toolbar, thus:
{«Toggle» Please Do NOT Forward¶
Address Correction Requested¶
}«Addressee Name»¶

4. Now fill in the rest of the field so that you end up with:
{IF«Toggle»<> "" "Please Do NOT Forward¶
Address Correction Requested¶
"}«Addressee Name»¶
deleting any extraneous spaces in the field. Note the positioning of the double quotes surrounding your message.

5. Run your mailmerge


--
Cheers
macropod
[MVP - Microsoft Word]


macropod,

First, thanks for your reply...

Please see my reply to Doug - much of it applies here.
You addressed a solution to my problem but didn't
elaborate of how to do it. (I've highlighted your
reference in red below.)

Unfortunately you didn't provide an example of *how*
to build the *IF* statement that will do what I need.
For example, you suggested:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
What I need is:
{IF«Toggle»<> "N" "Insert/Display Frame with text"}
or
{IF«Toggle»<> "N" "Insert/Display Image of border with text"}

It's that part which I haven't been able to find explained
somewhere.

David

macropod said:
Hi David,

To conditionally insert something based on the presence of any content in a data field for a mailmerge, you can use an IF test,
coded along the lines of:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
where 'Toggle' is the name of your data field.

Alternatively, to conditionally insert something based on the presence of a specified content in a data field for a mailmerge, you
can use an IF test, coded along the lines of:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied"}
where 'Toggle' is the name of your data field and 'Condition' is the whatever is required to be present before the output is
displayed.

In both cases, you can even 'toggle' the text to be displayed. For example:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied" "Content to output if Toggle condition is NOT
satisfied"}

In each case, the 'output' can include text, shapes, pictures, other mergefields, etc.

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likwise, you can't type the chevrons (ie '« »') - they're part of the actual mergefields, which you can
insert from the mailmerge toolbar.

--
Cheers
macropod
[MVP - Microsoft Word]


David Schrader said:
Hello all, hope this is the correct news group for this question...

The basics:

- I am using Office 2003 with all updates and bug-fixes.
- I send a monthly newsletter to 60-75 some-odd people.
- The list of names and addresses is stored in an Excel file
- I use mailmerge to print both the letter and the envelope
(and it works without any problems).

The problem and the need:

From time to time the envelope is returned with "Addressee
Unknown." The USPS people and they've said that this
usually happens when "forwarding" has expired. (By then
it's too late to request a forwarding address, all of the
information has been discarded.)

I'd like to print "Do not Forward. Address correction
requested." on the envelope (using a frame) from time to
time. I can easily add a field in the database to "toggle"
between displaying or not displaying the message. I do
not want to print it each month - just two or three times
a year.

My problem is that I haven't been able to find a way to
insert a word "Field" which can/will display or hide the
Word "frame" based upon the status of the Excel toggle
field. (Or, for that matter an "ASK" field or a bookmark.)

Question:

Can this be done and, if so, can someone provide a simple
example of how it would be done? Excel field preferred but
I'll take an ASK or bookmark too.

Many thanks in advance.

David
 
M

macropod

Hi David,

To get the textbox to anchor to a particular position in the field, format its layout as left of character (Format|Textbox|Layout|Advanced>Alignment>Left> relative to 'Character'> OK|OK. Then drag the anchor to the desired character position. Having done that, lock the anchor into position (Format|Textbox|Layout|Advanced>Lock Anchor>OK|OK and position the textbox where you want it to appear relative to the position to which you've anchored it.

--
Cheers
macropod
[MVP - Microsoft Word]


macropod,

Sorry for the delay, the kids got a new version of
W_O_W and it took a while to get my turn.

I tried what you suggested. Some worked, some
didn't. I couldn't find a method of dropping a text
box (with out without text) into a IF-ELSE field.
The anchor.Cross didn't want to settle into the
field.

Using text alone seemed to work without any
problems but I'm still deprived of the having a
text "frame."

I'll play with it a while longer before I give up.
If I do finally get it working I'll report back here.

David

Hi David,

As previously posted, you can use an IF test coded along the lines of:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
where 'Toggle' is the name of your data field.

Here are some step-by-step instructions on how to create this on your envelope mailmerge main document:
1. Create and format the text with the encompassing frame in a pair of paragraphs preceding the first mergefield on your envelope. This should give you something laid out like:
Please Do NOT Forward¶
Address Correction Requested¶
«Addressee Name»¶

2. Select the two framed paragraphs, including both paragraph markers and press Ctrl-F9. This will enclose them in a pair of field braces, thus:
{ Please Do NOT Forward¶
Address Correction Requested¶
}«Addressee Name»¶

3. After the left-hand field brace, insert your 'toggle' field via the mailmerge toolbar, thus:
{«Toggle» Please Do NOT Forward¶
Address Correction Requested¶
}«Addressee Name»¶

4. Now fill in the rest of the field so that you end up with:
{IF«Toggle»<> "" "Please Do NOT Forward¶
Address Correction Requested¶
"}«Addressee Name»¶
deleting any extraneous spaces in the field. Note the positioning of the double quotes surrounding your message.

5. Run your mailmerge


--
Cheers
macropod
[MVP - Microsoft Word]


macropod,

First, thanks for your reply...

Please see my reply to Doug - much of it applies here.
You addressed a solution to my problem but didn't
elaborate of how to do it. (I've highlighted your
reference in red below.)

Unfortunately you didn't provide an example of *how*
to build the *IF* statement that will do what I need.
For example, you suggested:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
What I need is:
{IF«Toggle»<> "N" "Insert/Display Frame with text"}
or
{IF«Toggle»<> "N" "Insert/Display Image of border with text"}

It's that part which I haven't been able to find explained
somewhere.

David

macropod said:
Hi David,

To conditionally insert something based on the presence of any content in a data field for a mailmerge, you can use an IF test,
coded along the lines of:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
where 'Toggle' is the name of your data field.

Alternatively, to conditionally insert something based on the presence of a specified content in a data field for a mailmerge, you
can use an IF test, coded along the lines of:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied"}
where 'Toggle' is the name of your data field and 'Condition' is the whatever is required to be present before the output is
displayed.

In both cases, you can even 'toggle' the text to be displayed. For example:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied" "Content to output if Toggle condition is NOT
satisfied"}

In each case, the 'output' can include text, shapes, pictures, other mergefields, etc.

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likwise, you can't type the chevrons (ie '« »') - they're part of the actual mergefields, which you can
insert from the mailmerge toolbar.

--
Cheers
macropod
[MVP - Microsoft Word]


David Schrader said:
Hello all, hope this is the correct news group for this question...

The basics:

- I am using Office 2003 with all updates and bug-fixes.
- I send a monthly newsletter to 60-75 some-odd people.
- The list of names and addresses is stored in an Excel file
- I use mailmerge to print both the letter and the envelope
(and it works without any problems).

The problem and the need:

From time to time the envelope is returned with "Addressee
Unknown." The USPS people and they've said that this
usually happens when "forwarding" has expired. (By then
it's too late to request a forwarding address, all of the
information has been discarded.)

I'd like to print "Do not Forward. Address correction
requested." on the envelope (using a frame) from time to
time. I can easily add a field in the database to "toggle"
between displaying or not displaying the message. I do
not want to print it each month - just two or three times
a year.

My problem is that I haven't been able to find a way to
insert a word "Field" which can/will display or hide the
Word "frame" based upon the status of the Excel toggle
field. (Or, for that matter an "ASK" field or a bookmark.)

Question:

Can this be done and, if so, can someone provide a simple
example of how it would be done? Excel field preferred but
I'll take an ASK or bookmark too.

Many thanks in advance.

David
 
D

David Schrader

I will try and reply.

David

Hi David,

To get the textbox to anchor to a particular position in the field, format its layout as left of character (Format|Textbox|Layout|Advanced>Alignment>Left> relative to 'Character'> OK|OK. Then drag the anchor to the desired character position. Having done that, lock the anchor into position (Format|Textbox|Layout|Advanced>Lock Anchor>OK|OK and position the textbox where you want it to appear relative to the position to which you've anchored it.

--
Cheers
macropod
[MVP - Microsoft Word]


macropod,

Sorry for the delay, the kids got a new version of
W_O_W and it took a while to get my turn.

I tried what you suggested. Some worked, some
didn't. I couldn't find a method of dropping a text
box (with out without text) into a IF-ELSE field.
The anchor.Cross didn't want to settle into the
field.

Using text alone seemed to work without any
problems but I'm still deprived of the having a
text "frame."

I'll play with it a while longer before I give up.
If I do finally get it working I'll report back here.

David

Hi David,

As previously posted, you can use an IF test coded along the lines of:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
where 'Toggle' is the name of your data field.

Here are some step-by-step instructions on how to create this on your envelope mailmerge main document:
1. Create and format the text with the encompassing frame in a pair of paragraphs preceding the first mergefield on your envelope. This should give you something laid out like:
Please Do NOT Forward¶
Address Correction Requested¶
«Addressee Name»¶

2. Select the two framed paragraphs, including both paragraph markers and press Ctrl-F9. This will enclose them in a pair of field braces, thus:
{ Please Do NOT Forward¶
Address Correction Requested¶
}«Addressee Name»¶

3. After the left-hand field brace, insert your 'toggle' field via the mailmerge toolbar, thus:
{«Toggle» Please Do NOT Forward¶
Address Correction Requested¶
}«Addressee Name»¶

4. Now fill in the rest of the field so that you end up with:
{IF«Toggle»<> "" "Please Do NOT Forward¶
Address Correction Requested¶
"}«Addressee Name»¶
deleting any extraneous spaces in the field. Note the positioning of the double quotes surrounding your message.

5. Run your mailmerge


--
Cheers
macropod
[MVP - Microsoft Word]


macropod,

First, thanks for your reply...

Please see my reply to Doug - much of it applies here.
You addressed a solution to my problem but didn't
elaborate of how to do it. (I've highlighted your
reference in red below.)

Unfortunately you didn't provide an example of *how*
to build the *IF* statement that will do what I need.
For example, you suggested:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
What I need is:
{IF«Toggle»<> "N" "Insert/Display Frame with text"}
or
{IF«Toggle»<> "N" "Insert/Display Image of border with text"}

It's that part which I haven't been able to find explained
somewhere.

David

macropod said:
Hi David,

To conditionally insert something based on the presence of any content in a data field for a mailmerge, you can use an IF test,
coded along the lines of:
{IF«Toggle»<> "" "Content to output if Toggle is not empty"}
where 'Toggle' is the name of your data field.

Alternatively, to conditionally insert something based on the presence of a specified content in a data field for a mailmerge, you
can use an IF test, coded along the lines of:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied"}
where 'Toggle' is the name of your data field and 'Condition' is the whatever is required to be present before the output is
displayed.

In both cases, you can even 'toggle' the text to be displayed. For example:
{IF«Toggle»= "Condition" "Content to output if Toggle condition is satisfied" "Content to output if Toggle condition is NOT
satisfied"}

In each case, the 'output' can include text, shapes, pictures, other mergefields, etc.

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message. Likwise, you can't type the chevrons (ie '« »') - they're part of the actual mergefields, which you can
insert from the mailmerge toolbar.

--
Cheers
macropod
[MVP - Microsoft Word]


David Schrader said:
Hello all, hope this is the correct news group for this question...

The basics:

- I am using Office 2003 with all updates and bug-fixes.
- I send a monthly newsletter to 60-75 some-odd people.
- The list of names and addresses is stored in an Excel file
- I use mailmerge to print both the letter and the envelope
(and it works without any problems).

The problem and the need:

From time to time the envelope is returned with "Addressee
Unknown." The USPS people and they've said that this
usually happens when "forwarding" has expired. (By then
it's too late to request a forwarding address, all of the
information has been discarded.)

I'd like to print "Do not Forward. Address correction
requested." on the envelope (using a frame) from time to
time. I can easily add a field in the database to "toggle"
between displaying or not displaying the message. I do
not want to print it each month - just two or three times
a year.

My problem is that I haven't been able to find a way to
insert a word "Field" which can/will display or hide the
Word "frame" based upon the status of the Excel toggle
field. (Or, for that matter an "ASK" field or a bookmark.)

Question:

Can this be done and, if so, can someone provide a simple
example of how it would be done? Excel field preferred but
I'll take an ASK or bookmark too.

Many thanks in advance.

David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top