PDA

View Full Version : Macro at document open - mail merge



gregbartel
01-29-2013, 03:18 AM
I'm not a programmer for Office but I have a task to write a script for Word.
I have a Word document that is ready to print mailing a letter to multiple recipients.
Up to this point, each user opens the Word file and manually point to a ready list of recipients of the letter are taken from an Excel file (file, open) etc..
Now I need to show the file-browsing window and select a file with a list of recipients (xls file) when the user opens the Word document.
Once he has chosen the data from xls file Word fill this letter and will be able to print a list of the selected recipients.
Browse window and select xls file is needed because the xls document each time has a different name.

Can I ask for such a macro?

macropod
01-30-2013, 01:18 AM
It would be simpler to make a re-named copy of the data file, using the same filename each time for the mailmerge.