Solved

Mail Merge with Pivot Table (BLANK) problem

Posted on 2014-04-17
5
1,189 Views
Last Modified: 2014-04-24
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
Comment
Question by:Michael Franz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 13

Expert Comment

by:Santosh Gupta
ID: 40007212
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
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 40007231
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
 

Author Comment

by:Michael Franz
ID: 40007381
Graham,

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

Customer Name
Address
 {MERGEFIELD
CityStZip
Image.doc
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 40007500
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
 

Author Closing Comment

by:Michael Franz
ID: 40020876
Nice, got it
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question