View Single Post
  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Delete a table row when mergefield is blank??

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]


"NaBellFL" wrote in message ...
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.

{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}:

"macropod" wrote:

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]


"NaBellFL" wrote in message ...
I create a form letter. The information of the letter is in a table.
Example:
{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" wrote:

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" wrote in message
...
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.