Apostrophes in Mail Merge fields

[Lesley W]

When I use an apostrophe in a mail merge field it doesn't use a typographers quotes type of apostrophe so when the field is merged it doesn't match the apostrophes in the rest of the document. Is there a way around this other than doing a search and replace once I have completed the merge?

 

[Graham Mayor]

Use autoformat -
The following macro will do that applying the appropriate settings:

With Options
.AutoFormatApplyHeadings = False
.AutoFormatApplyLists = False
.AutoFormatApplyBulletedLists = False
.AutoFormatApplyOtherParas = False
.AutoFormatReplaceQuotes = True
.AutoFormatReplaceSymbols = False
.AutoFormatReplaceOrdinals = False
.AutoFormatReplaceFractions = False
.AutoFormatReplacePlainTextEmphasis = False
.AutoFormatReplaceHyperlinks = False
.AutoFormatPreserveStyles = False
.AutoFormatPlainTextWordMail = False
End With
Selection.Document.Kind = wdDocumentNotSpecified
Selection.Range.AutoFormat

See http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Lesley W]

Sorry Graham - this is all gibberish to me as I have no knowledge of macros at all. If (assuming I can somehow set up the correct macro) I have to run a macro after each mail merge I can't see it being much different to doing a search and replace on the apostrophes anyway. Thank you for your reply though - I appreciate the fact that there is someone to ask about problems such as this.
Lesley

 

[Graham Mayor]

Lesley
At the end of the macro code there is a link to my web page which explains
how to use macro code from newsgroups. All this code does is sets up the
environment to run autocorrect to convert to smart quotes. You can do that
manually from Format > autoformat. The macro simply removes a load of
keystrokes. If the macro is attached to a toolbar button. One click will
reformat your merges.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[John Galt]

Does this apply to the master excel spreadsheet that the mail merge is
pulling data from?

 

[Graham Mayor]

No - it is intended to work on the document merged to.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>