Macro running on its own

[John]

I have a macro which looks in a folder, converts .wpd files into Word files and then runs a mail merge. Is it possible to have the macro execute on its own based upon some triggering event? I'd like to be able to have users continually add files to a folder and have the macro run when needed. Any suggestions?

Thanks in advance.
John

 

[Perry]

Check out following articles:
http://www.mvps.org/word/FAQs/MacrosVBA/ApplicationEvents.htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd10/htm
l/wohowautomacros.asp

If this turns out not helpfull, pls elaborate some more on what
you want to achieve.

Krgrds,
Perry

I have a macro which looks in a folder, converts .wpd files into Word

files and then runs a mail merge. Is it possible to have the macro execute
on its own based upon some triggering event? I'd like to be able to have
users continually add files to a folder and have the macro run when needed.
Any suggestions?