Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1425
  • Last Modified:

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
0
Michael Franz
Asked:
Michael Franz
  • 2
  • 2
1 Solution
 
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
 
GrahamSkanRetiredCommented:
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
 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now