Solved

More Mail Merge Woes

Posted on 2013-12-03
4
202 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 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
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 the word count, how to display it, and what it breaks down to in Microsoft Word.

730 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