Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mailmerge from excel button
Hi,
I have a macro in word that create a mailmerge. I would like to execute this Macro from excel button. Also, the excel file contains all the merge data used by Word. I tried to open the word mailmerge document in excel by since it is linked to the actual excel data, it must close excel workbook and re-open it. This stop the macro. So, I would like to do the following: 1- In excel, there is a sheet which contains the merge data 2- You click on a button Excel and select the mailmerge document 3- Save the excel workbook to a temporary file #2 and close the file #1 (if required) ?? (stop macro execution) 4- Open the word document and set the word data merge equal excel data merge 5- Execute the word macro inside word to create the printmerge. From this way, since the mailmerge is a Macro from Word, it can be executed from excel or word. Is this, the best way to proceed ? Does anyone have a code that do something like that ? Thanks ;) -- Alex St-Pierre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I perform mailmerge in Excel | Excel Discussion (Misc queries) | |||
Mailmerge from a button in excel | Excel Programming | |||
can i use mailmerge to in excel like you would in word? | Excel Discussion (Misc queries) | |||
Mailmerge in Excel? | Excel Programming | |||
VBA mailmerge from Excel | Excel Programming |