Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mail merge with formulas

Status
Not open for further replies.

WingandaPrayer

Technical User
May 15, 2001
152
Hi all,

If you would give me some advice please.

I'm mail merging from a Progress program into Word.

I was using the word field IF option when a merge field was 'not blank' the £ symbol would be placed before the field. When the field was blank it obviously wouldn't show and the next line would shift up if blank. I had six lines where the IF option was used as the lines would shift up when blank.

Since then I have had to add a formula (merge field total *2) to each of these lines. I have tried the following in order for the lines to shift up one if the merge field is blank. One table containing all six lines, one table per line and using the bookmark. None of these options allow the lines to shift up if they are blank. As a result on occasion I have a six line blank space until the next field shows.

Is it me and one of the above three options I have tried should actually work?

cheers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top