Solved

More Mail Merge Woes

Posted on 2013-12-03
4
201 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
  • 2
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 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 500 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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

There is a feature provided by MS Word that lets you create an Table of Contents for your Word document automatically. To use this feature for other documents there are two steps involved,   1.  Prepare your document for a table of contents (he…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

828 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