K
Kerry Purdy
Hi,
I am using Word XP & Excel XP as my data source.
My data source has 5 address fields and a post code field, I also have a DX
address field. I would like the DX address to be shown on my mail merge
letters & envelopes if one is listed, otherwise I would like the 6 mailing
address field details to show.
I have managed this by using IF Then Else in my word document.
{IF {MERGEFIELD DX}=â€â€ “{MERGEFIELD Add1}†“{MERGEFIELD DX}â€}
{IF {MERGEFIELD DX}=â€â€ “{MERGEFIELD Add2}â€}
{IF {MERGEFIELD DX}=â€â€ “{MERGEFIELD Add3}â€}
{IF {MERGEFIELD DX}=â€â€ “{MERGEFIELD Add4}â€}
{IF {MERGEFIELD DX}=â€â€ “{MERGEFIELD Add5}â€}
{IF {MERGEFIELD DX}=â€â€ “{MERGEFIELD Postcode}â€}
This is working fine to a point - only showing the DX if there is data,
showing the mailing address if no DX details are recorded.
The problem I have is that it's printing the blank lines where an address
field has not been filled. If I have no Add3 value I have a blank line in my
envelope and letter. Also, where only a DX address is being printed is
doesn't close the spaces between that and the start of my letter.
I hope this question makes sense. Is there something I can add to my IF
Then Else? Do I need to try another method? Do you have any suggestions
please.
Manys thanks in advance for your time.
Kerry.
I am using Word XP & Excel XP as my data source.
My data source has 5 address fields and a post code field, I also have a DX
address field. I would like the DX address to be shown on my mail merge
letters & envelopes if one is listed, otherwise I would like the 6 mailing
address field details to show.
I have managed this by using IF Then Else in my word document.
{IF {MERGEFIELD DX}=â€â€ “{MERGEFIELD Add1}†“{MERGEFIELD DX}â€}
{IF {MERGEFIELD DX}=â€â€ “{MERGEFIELD Add2}â€}
{IF {MERGEFIELD DX}=â€â€ “{MERGEFIELD Add3}â€}
{IF {MERGEFIELD DX}=â€â€ “{MERGEFIELD Add4}â€}
{IF {MERGEFIELD DX}=â€â€ “{MERGEFIELD Add5}â€}
{IF {MERGEFIELD DX}=â€â€ “{MERGEFIELD Postcode}â€}
This is working fine to a point - only showing the DX if there is data,
showing the mailing address if no DX details are recorded.
The problem I have is that it's printing the blank lines where an address
field has not been filled. If I have no Add3 value I have a blank line in my
envelope and letter. Also, where only a DX address is being printed is
doesn't close the spaces between that and the start of my letter.
I hope this question makes sense. Is there something I can add to my IF
Then Else? Do I need to try another method? Do you have any suggestions
please.
Manys thanks in advance for your time.
Kerry.