Using Macro to Change case of text in merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jonno - 29 Feb 2008 08:58 GMT

I'm trying to run a merge from Goldmine to word 2003, however the
fields I'm bringing in are all in UPPERCASE, is it possible to run a
macro that changes the fields to title case?

The fields look like:
{DDEAUTO GoldMine Data &Company \*CHARFORMAT }

I've tried the usual right click "edit field" and change the case in
the properties dialogue - but it isn't listed as an option.. Any help
appreciated.

Thanks,

Jon

Reply to this Message

Doug Robbins - Word MVP - 29 Feb 2008 10:42 GMT

I think that you are going to have to run a macro over the document created
by executing the merge to a new document. Here is the code that you would
use:

Selection.HomeKey wdStory
Selection.Find.ClearFormatting
With Selection.Find
Do While .Execute(findText:="[A-Z]{2,}", Forward:=True, _
MatchWildcards:=True, MatchCase:=True, Wrap:=wdFindStop) = True
Found = True
Selection.Range.Case = wdTitleWord
Selection.Collapse wdCollapseEnd
Loop
End With

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm trying to run a merge from Goldmine to word 2003, however the
> fields I'm bringing in are all in UPPERCASE, is it possible to run a
[quoted text clipped - 10 lines]
>
> Jon

Reply to this Message

Summer - 29 Feb 2008 21:04 GMT

You might try putting in \* Caps (title case switch) and see if it works?

{ MERGEFIELD \* Caps \* CHARFORMAT}

Summer

www.docsliveonline

> I'm trying to run a merge from Goldmine to word 2003, however the
> fields I'm bringing in are all in UPPERCASE, is it possible to run a
[quoted text clipped - 10 lines]
>
> Jon

Reply to this Message

Rate this thread: