Delete a table row when mergefield is blank??

[NaBellFL]

I am using Word 2003. I have created a document which includes a table. In
each row I have placed my { mergefield }. When I merge the document, if
there is no data for a field then I need the table row to be deleted. Can I
use an {If, then, else} statement to accomplish this?

Any help is greatly appreciated.

 

[Doug Robbins - Word MVP]

That cannot be done using mail merge. Tell us exactly what you are trying
to do.

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

 

[NaBellFL]

I create a form letter. The re: information of the letter is in a table.
Example:
Re: {mergefield matter_name}
Co. File No. {mergefield matsup_cofile }
Etc.

This document is then merged. If there is no data in the cofile field of my
database I want to automoatically delete that table row from the merged
document.

I recorded a simple macro and created a toolbar button for it that the user
can use to delete the row after the merge but I wanted to find out if there
is a way to "nest" this macro in an If statement or something else???

I hope that clarifies what I am trying to do.

 

[macropod]

Hi NaBellFL,

You could achieve what you're after by placing the various mergefields on the same line with all except the first one embedded in IF
tests coded like:

{IF{MERGEFIELD matsup_cofile}<> "" "¶
{MERGEFIELD matsup_cofile}"}

where the '¶' is a proper paragraph mark or line-feed. That way, only the mergefields that have something in them will generate a
new line. No need for a macro.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

 

[NaBellFL]

Thanks for the response, I definitely learned something new. But, my table
rows are already established in my form letter (example below). I don't
believe I can use your IF statement or if I can I don't understand how. Any
other help would be greatly appreciated.

Re: {mergefield matter_name}
Co. Claim No. {mergefield matsup_courtno}
Co. File No. {mergefield matsup_cofile}
Suit File No. {mergefield matsup_suitfile}
Unit No. {mergefield matsup_unitno}
Policy No. {mergefield matsup_policyno}
Insured {mergefield r_insured_1_fullemp}
Date of Incident {mergefield matsup_lossdate}
Our File No. {mergefield matter_matcode}

Dear {mergefield recipient_salutation}:

Hi NaBellFL,

You could achieve what you're after by placing the various mergefields on the same line with all except the first one embedded in IF
tests coded like:

{IF{MERGEFIELD matsup_cofile}<> "" "¶
{MERGEFIELD matsup_cofile}"}

where the '¶' is a proper paragraph mark or line-feed. That way, only the mergefields that have something in them will generate a
new line. No need for a macro.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]

I create a form letter. The re: information of the letter is in a table.
Example:
Re: {mergefield matter_name}
Co. File No. {mergefield matsup_cofile }
Etc.

This document is then merged. If there is no data in the cofile field of my
database I want to automoatically delete that table row from the merged
document.

I recorded a simple macro and created a toolbar button for it that the user
can use to delete the row after the merge but I wanted to find out if there
is a way to "nest" this macro in an If statement or something else???

I hope that clarifies what I am trying to do.

 

[Doug Robbins - Word MVP]

While outside of a table (or within just one cell of a table) you can
prevent a blank line from occuring, as I said, you cannot get it to delete a
row from a table.

Do you have to use a table?

If you must use a table, you would need to use a "roll-your-own" equivalent
to mail merge using VBA.

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

Thanks for the response, I definitely learned something new. But, my
table
rows are already established in my form letter (example below). I don't
believe I can use your IF statement or if I can I don't understand how.
Any
other help would be greatly appreciated.

Re: {mergefield matter_name}
Co. Claim No. {mergefield matsup_courtno}
Co. File No. {mergefield matsup_cofile}
Suit File No. {mergefield matsup_suitfile}
Unit No. {mergefield matsup_unitno}
Policy No. {mergefield matsup_policyno}
Insured {mergefield r_insured_1_fullemp}
Date of Incident {mergefield matsup_lossdate}
Our File No. {mergefield matter_matcode}

Dear {mergefield recipient_salutation}:

Hi NaBellFL,

You could achieve what you're after by placing the various mergefields on
the same line with all except the first one embedded in IF
tests coded like:

{IF{MERGEFIELD matsup_cofile}<> "" "¶
{MERGEFIELD matsup_cofile}"}

where the '¶' is a proper paragraph mark or line-feed. That way, only the
mergefields that have something in them will generate a
new line. No need for a macro.

Note: The field brace pairs (ie '{ }') for the above example are created
via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]

I create a form letter. The re: information of the letter is in a
table.
Example:
Re: {mergefield matter_name}
Co. File No. {mergefield matsup_cofile }
Etc.

This document is then merged. If there is no data in the cofile field
of my
database I want to automoatically delete that table row from the merged
document.

I recorded a simple macro and created a toolbar button for it that the
user
can use to delete the row after the merge but I wanted to find out if
there
is a way to "nest" this macro in an If statement or something else???

I hope that clarifies what I am trying to do.

:

That cannot be done using mail merge. Tell us exactly what you are
trying
to do.

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

I am using Word 2003. I have created a document which includes a
table.
In
each row I have placed my { mergefield }. When I merge the
document, if
there is no data for a field then I need the table row to be
deleted. Can
I
use an {If, then, else} statement to accomplish this?

Any help is greatly appreciated.

 

[macropod]

Hi NaBellFL,

Whilst you can add/delete rows via mailmerge field coding, you can format the mailmerge paragraph borders, if you want, to simulate
a table. That may suffice for your needs.

--
Cheers
macropod
[MVP - Microsoft Word]

Thanks for the response, I definitely learned something new. But, my table
rows are already established in my form letter (example below). I don't
believe I can use your IF statement or if I can I don't understand how. Any
other help would be greatly appreciated.

Re: {mergefield matter_name}
Co. Claim No. {mergefield matsup_courtno}
Co. File No. {mergefield matsup_cofile}
Suit File No. {mergefield matsup_suitfile}
Unit No. {mergefield matsup_unitno}
Policy No. {mergefield matsup_policyno}
Insured {mergefield r_insured_1_fullemp}
Date of Incident {mergefield matsup_lossdate}
Our File No. {mergefield matter_matcode}

Dear {mergefield recipient_salutation}:

Hi NaBellFL,

You could achieve what you're after by placing the various mergefields on the same line with all except the first one embedded in
IF
tests coded like:

{IF{MERGEFIELD matsup_cofile}<> "" "¶
{MERGEFIELD matsup_cofile}"}

where the '¶' is a proper paragraph mark or line-feed. That way, only the mergefields that have something in them will generate a
new line. No need for a macro.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]

I create a form letter. The re: information of the letter is in a table.
Example:
Re: {mergefield matter_name}
Co. File No. {mergefield matsup_cofile }
Etc.

This document is then merged. If there is no data in the cofile field of my
database I want to automoatically delete that table row from the merged
document.

I recorded a simple macro and created a toolbar button for it that the user
can use to delete the row after the merge but I wanted to find out if there
is a way to "nest" this macro in an If statement or something else???

I hope that clarifies what I am trying to do.

:

That cannot be done using mail merge. Tell us exactly what you are trying
to do.

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

I am using Word 2003. I have created a document which includes a table.
In
each row I have placed my { mergefield }. When I merge the document, if
there is no data for a field then I need the table row to be deleted. Can
I
use an {If, then, else} statement to accomplish this?

Any help is greatly appreciated.

 

[Doug Robbins - Word MVP]

I guess "can" was meant to be "cannot"

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

Hi NaBellFL,

Whilst you can add/delete rows via mailmerge field coding, you can format
the mailmerge paragraph borders, if you want, to simulate a table. That
may suffice for your needs.

--
Cheers
macropod
[MVP - Microsoft Word]

Thanks for the response, I definitely learned something new. But, my
table
rows are already established in my form letter (example below). I don't
believe I can use your IF statement or if I can I don't understand how.
Any
other help would be greatly appreciated.

Re: {mergefield matter_name}
Co. Claim No. {mergefield matsup_courtno}
Co. File No. {mergefield matsup_cofile}
Suit File No. {mergefield matsup_suitfile}
Unit No. {mergefield matsup_unitno}
Policy No. {mergefield matsup_policyno}
Insured {mergefield r_insured_1_fullemp}
Date of Incident {mergefield matsup_lossdate}
Our File No. {mergefield matter_matcode}

Dear {mergefield recipient_salutation}:

Hi NaBellFL,

You could achieve what you're after by placing the various mergefields
on the same line with all except the first one embedded in IF
tests coded like:

{IF{MERGEFIELD matsup_cofile}<> "" "¶
{MERGEFIELD matsup_cofile}"}

where the '¶' is a proper paragraph mark or line-feed. That way, only
the mergefields that have something in them will generate a
new line. No need for a macro.

Note: The field brace pairs (ie '{ }') for the above example are created
via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


I create a form letter. The re: information of the letter is in a
table.
Example:
Re: {mergefield matter_name}
Co. File No. {mergefield matsup_cofile }
Etc.

This document is then merged. If there is no data in the cofile field
of my
database I want to automoatically delete that table row from the
merged
document.

I recorded a simple macro and created a toolbar button for it that the
user
can use to delete the row after the merge but I wanted to find out if
there
is a way to "nest" this macro in an If statement or something else???

I hope that clarifies what I am trying to do.

:

That cannot be done using mail merge. Tell us exactly what you are
trying
to do.

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

I am using Word 2003. I have created a document which includes a
table.
In
each row I have placed my { mergefield }. When I merge the
document, if
there is no data for a field then I need the table row to be
deleted. Can
I
use an {If, then, else} statement to accomplish this?

Any help is greatly appreciated.

 

[macropod]

Umm ... can't

--
Cheers
macropod
[MVP - Microsoft Word]

I guess "can" was meant to be "cannot"

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

Hi NaBellFL,

Whilst you can add/delete rows via mailmerge field coding, you can format the mailmerge paragraph borders, if you want, to
simulate a table. That may suffice for your needs.

--
Cheers
macropod
[MVP - Microsoft Word]

Thanks for the response, I definitely learned something new. But, my table
rows are already established in my form letter (example below). I don't
believe I can use your IF statement or if I can I don't understand how. Any
other help would be greatly appreciated.

Re: {mergefield matter_name}
Co. Claim No. {mergefield matsup_courtno}
Co. File No. {mergefield matsup_cofile}
Suit File No. {mergefield matsup_suitfile}
Unit No. {mergefield matsup_unitno}
Policy No. {mergefield matsup_policyno}
Insured {mergefield r_insured_1_fullemp}
Date of Incident {mergefield matsup_lossdate}
Our File No. {mergefield matter_matcode}

Dear {mergefield recipient_salutation}:

:

Hi NaBellFL,

You could achieve what you're after by placing the various mergefields on the same line with all except the first one embedded
in IF
tests coded like:

{IF{MERGEFIELD matsup_cofile}<> "" "¶
{MERGEFIELD matsup_cofile}"}

where the '¶' is a proper paragraph mark or line-feed. That way, only the mergefields that have something in them will generate
a
new line. No need for a macro.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy &
paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


I create a form letter. The re: information of the letter is in a table.
Example:
Re: {mergefield matter_name}
Co. File No. {mergefield matsup_cofile }
Etc.

This document is then merged. If there is no data in the cofile field of my
database I want to automoatically delete that table row from the merged
document.

I recorded a simple macro and created a toolbar button for it that the user
can use to delete the row after the merge but I wanted to find out if there
is a way to "nest" this macro in an If statement or something else???

I hope that clarifies what I am trying to do.

:

That cannot be done using mail merge. Tell us exactly what you are trying
to do.

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

I am using Word 2003. I have created a document which includes a table.
In
each row I have placed my { mergefield }. When I merge the document, if
there is no data for a field then I need the table row to be deleted. Can
I
use an {If, then, else} statement to accomplish this?

Any help is greatly appreciated.