 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / November 2004Apostrophes in Mail Merge fields
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? 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  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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? 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 > Use autoformat - > The following macro will do that applying the appropriate settings: [quoted text clipped - 23 lines] > > way around this other than doing a search and replace once I have > > completed the merge? 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. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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 [quoted text clipped - 40 lines] >>> way around this other than doing a search and replace once I have >>> completed the merge? Does this apply to the master excel spreadsheet that the mail merge is pulling data from? > Lesley > At the end of the macro code there is a link to my web page which explains [quoted text clipped - 48 lines] > >>> way around this other than doing a search and replace once I have > >>> completed the merge? No - it is intended to work on the document merged to. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Does this apply to the master excel spreadsheet that the mail merge is > pulling data from? [quoted text clipped - 60 lines] >>>>> way around this other than doing a search and replace once I have >>>>> completed the merge? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.