Creating a macro for a merged word document

[Cybershmuck]

Hi,

I’m using Word 2003 and would like to know how to add a macro that would perform the following task after a word merge:

1.Select the entire document by pressing CTRL + A
2.Go to Tools > Language > Set Language
3.Select English (Australia) for ‘Mark selected text
4.Uncheck the tick box ‘Do not check spelling or grammar’
5.Click OK

Please advise.

Thanks

 

[TonyJollans]

[blue]With ActiveDocument.Content
    .LanguageID=wdEnglishAUS
    .NoProofing = True
End With[/blue]

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[macropod]

Hi Cybershmuck,

Why do you need a macro to do what you should do to the mailmerge main document before running the merge?

Tony: I think that should be '.NoProofing = False'

Cheers

[MS MVP - Word]

 

[TonyJollans]

Thank you, macropod, I need someone to watch my every move <g>

You're absolutely right - I missed the UN in UNcheck.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[Cybershmuck]

Thanks guys it work !

 

[mscallisto]

Cybershmuck

you asked:

would like to know how to add a macro

You can record your own macro:
Tools > Macro > Record new macro

Then click:
Select the entire document by pressing CTRL + A
Go to Tools > Language > Set Language
Select English (Australia) for 'Mark selected text
Uncheck the tick box 'Do not check spelling or grammar'
OK

sam


Then click Stop Recording (the small solid square)

Next click [Alt F11] to see your macro



Sub Macro1()
Selection.WholeStory
Selection.LanguageID = wdEnglishAUS
Selection.NoProofing = False
Application.CheckLanguage = True
End Sub

 

[Cybershmuck]

Hi all,

The macro works fine except that it only runs after I input a keystroke. How can I get this spell check to run automatically afte the document had been merged.

Cheers,

Stanley