Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How can I record a macro, with a pause, and then resume the macro to make a
mail merge. Data for merge is stored in Excel. Form is set up in Word. I can't get the macro to record. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm not sure if this is true, but I think I'd record the macro while in MSWord.
I would think that it would be easier there (from someone who hasn't done this). If you think that it might be true, you may want to post in one of the MSWord newsgroups. Wonder Women wrote: How can I record a macro, with a pause, and then resume the macro to make a mail merge. Data for merge is stored in Excel. Form is set up in Word. I can't get the macro to record. -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sorry -- but this is what I have done and it will not record the macro. I
start out getting the form in word and the macro works until I try to do the mail merge section. Anyone, help??? "Wonder Women" wrote: How can I record a macro, with a pause, and then resume the macro to make a mail merge. Data for merge is stored in Excel. Form is set up in Word. I can't get the macro to record. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you started the process in MSWord and used MSWord's macro recorder, you may
want to post to an MSWord newsgroup. Wonder Women wrote: Sorry -- but this is what I have done and it will not record the macro. I start out getting the form in word and the macro works until I try to do the mail merge section. Anyone, help??? "Wonder Women" wrote: How can I record a macro, with a pause, and then resume the macro to make a mail merge. Data for merge is stored in Excel. Form is set up in Word. I can't get the macro to record. -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I hardly ever use Word but I was doing volunteer work at an organization that wanted to run mailing labels in Word. I set up the list(s) in Excel with macros to create sublists and then, after much effort made my one and only macro in Word to select the sublists and run the labels. I used the following MS article as a basis and stumbled along and finally got something to work: http://support.microsoft.com/?id=258512 HOWTO Automate Word from Visual Basic to Create a Mail Merge for Mailing Labels.htm If you have problems and need assistance you can email me. CHORDially, Art Farrell "Wonder Women" wrote in message ... Sorry -- but this is what I have done and it will not record the macro. I start out getting the form in word and the macro works until I try to do the mail merge section. Anyone, help??? "Wonder Women" wrote: How can I record a macro, with a pause, and then resume the macro to make a mail merge. Data for merge is stored in Excel. Form is set up in Word. I can't get the macro to record. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Link excel and word in mail merge without losing your data source? | Excel Discussion (Misc queries) | |||
How to filter on a date field during mail merge | Excel Worksheet Functions | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
F7 in zip field when doing mail merge from excell file | Excel Discussion (Misc queries) | |||
Mail merge to a chart | Charts and Charting in Excel |