More Mail Merge Woes

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
frugalmuleAsked:
Who is Participating?
 
GrahamSkanConnect With a Mentor RetiredCommented:
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
 
frugalmuleAuthor Commented:
I'm a little lost.can you provide more specifics about how to implement that precisely?
0
 
GrahamSkanConnect With a Mentor RetiredCommented:
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
 
frugalmuleAuthor Commented:
I think I am getting closer but not quite there http://screencast.com/t/1JFtnwJN
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.