#1   Report Post  
Posted to microsoft.public.excel.misc
Wonder Women
 
Posts: n/a
Default Mail Merge macro

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   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Mail Merge macro

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   Report Post  
Posted to microsoft.public.excel.misc
Wonder Women
 
Posts: n/a
Default Mail Merge macro

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   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Mail Merge macro

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   Report Post  
Posted to microsoft.public.excel.misc
Art Farrell
 
Posts: n/a
Default Mail Merge macro

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link excel and word in mail merge without losing your data source? angie Excel Discussion (Misc queries) 5 July 1st 05 06:29 PM
How to filter on a date field during mail merge SWADoug Excel Worksheet Functions 0 June 21st 05 06:31 PM
Different graphic for each record in mail merge document Alex St-Pierre Charts and Charting in Excel 1 May 4th 05 07:26 PM
F7 in zip field when doing mail merge from excell file kshinn15 Excel Discussion (Misc queries) 0 April 16th 05 09:52 PM
Mail merge to a chart Alex St-Pierre Charts and Charting in Excel 1 November 28th 04 05:05 PM


All times are GMT +1. The time now is 04:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"