Solved

Mail Merge with Pivot Table (BLANK) problem

Posted on 2014-04-17
5
925 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:Newbi22
  • 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:Newbi22
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:Newbi22
ID: 40020876
Nice, got it
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now