?
Solved

More Mail Merge Woes

Posted on 2013-12-03
4
Medium Priority
?
204 Views
Last Modified: 2013-12-17
I managed to get the labels merged correctly but am having trouble with the attached document and and excel file.  

On the labels, the <<alabel1>> worked flawlessly without double spacing them but on the document, it double spaces them.

The salutation also works but not is not quite right.  For the salutation, I need a condition that if it is blank, it should say "Dear Hiring Manager" instead of Dear <<field>> .  

Assistance with the attached files is greatly appreciated.
MergeCos.xlsx
131117-Draft-Generic-Letter-to-E.docx
0
Comment
Question by:frugalmule
[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
4 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 2000 total points
ID: 39694280
For the address block spacing, change the paragraph style of the paragraph with the field to one with suitable spacing. Alternatively, you can change the settings for that paragraph directly. The settings are on the Indents and Spacing tab of the Paragraph dialogue.

You can use an IF field to test for a blank result and show the text or the field, depending on the result.

Use Alt+F9 to display the field codes. You need it to look like this:

Dear { IF {MERGEFIELD Key_Decision_Maker} = "" "Hiring Manager" " { MERGEFIELD Key_Decision_Maker }" }

Note that the field delimiters represented by curly brackets cannot be entered directly, but must be entered as part of a field from the Field dialogue or by the use of Ctrl+F9.

When done, you can use Alt+F9 again to toggle back to the field results view.
0
 

Author Comment

by:frugalmule
ID: 39694325
I'm a little lost.can you provide more specifics about how to implement that precisely?
0
 
LVL 76

Assisted Solution

by:GrahamSkan
GrahamSkan earned 2000 total points
ID: 39694953
How far do you get before getting stuck?

If you are having trouble with editing the fields, you might want to try entering them as text and converting to fields with the code in the article:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/A_7236-Macro-code-to-convert-text-to-fields-in-Microsoft-Word.html
0
 

Author Comment

by:frugalmule
ID: 39696141
I think I am getting closer but not quite there http://screencast.com/t/1JFtnwJN
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
Suggested Courses

743 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