Mail Merge with Pivot Table (BLANK) problem

I am using a pivot table to create a mail merge. I have an address 1 and address 2. The address 2 field contains about 50% (blank) results from the pivot table which causes a problem in my mail merge.

Pivot Table

Customer Name      Address      Address #2      City      St      Zip
M Newbie       1014 Caswell      (blank)      Sleepy      IL      61000
M Jackson        12 Wonder Ld  Apt 22     Sneezy     KS    56789



M Newbie
1014 Caswell
(blank)
Sleepy, IL 61000

M Jackson
12 Wonder Ld
Apt 22
Sneezy, KS 56789
Michael FranzCFOAsked:
Who is Participating?
 
GrahamSkanConnect With a Mentor RetiredCommented:
You can use an IF field to test the text and only show it if it is not "(blank)"

Use the Alt+F9 toggle to show the field codes in the main document so that
<<Address2>> becomes  { MERGEFIELD Address2 }.

Select the field and use Ctrl+F9 to create an extra pair of field delimiters so that it looks like this: { { MERGEFIELD Address2 } }

Copy the field so that it appears twice within the outer pair of delimiters and then type in the extra text so that it looks like this:

 { IF { MERGEFIELD Address2 } = "(Blank)" "" "{ MERGEFIELD Address2 }" }
0
 
Santosh GuptaCommented:
Not sure about your actual issue but if you could search blank cell and replace with a SPACE then might be you mail merge work.
0
 
Michael FranzCFOAuthor Commented:
Graham,

I think that I am close..... I have this....showing as a result.....

Customer Name
Address
 {MERGEFIELD
CityStZip
Image.doc
0
 
GrahamSkanRetiredCommented:
Pictures cannot be analysed, so are a poor substitute for an actual document.

If you have a curly bracket showing in the result document, then it has been entered directly as such a character from the keyboard and not as part of a field insert or with Ctrl+F9.

Field delimiters are displayed as curly brackets, but they are not the same thing.
0
 
Michael FranzCFOAuthor Commented:
Nice, got it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.