Solved

More Mail Merge Woes

Posted on 2013-12-03
4
198 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
I think I am getting closer but not quite there http://screencast.com/t/1JFtnwJN
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
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.

772 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

11 Experts available now in Live!

Get 1:1 Help Now