#1   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 08:12 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"