View Single Post
 
Old 07-11-2019, 02:58 AM
gizmo83 gizmo83 is offline Windows 10 Office 2019
Novice
 
Join Date: Jul 2019
Posts: 3
gizmo83 is on a distinguished road
Default Mail Merge Suppression issue

Hello,

I have a dataset which includes several criteria for Mail merge. However, those which contain a zero value should not be included in the merge, and the line they exist on should be suppressed to ensure good formatting. However, I am unable to achieve this.

Essentially, it's this.

The data is in Excel, with Field name, and field value)

Field Name 1: £100 (this should be included)
Field Name 2: £0 (this should be suppressed)
Field Name 3: £120 (this should be included)
*Just to add, the title (shown as Field Name 1 etc.) also needs to be suppressed.

Is there anything I can do to achieve the desired outcome?

Thank you so much for any help!
Gio
Reply With Quote