Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
biff biff is offline
external usenet poster
 
Posts: 6
Default using macros with mailmerge

I am wondering how much I can use macros to take care of steps used in a
mailmerge.

I have an Excel spreadsheet that has column headers and rows of records. I
want to use the data from that spreadsheet to make labels in Word's mailmerge.

I know that I have to use a custom size label so I am assuming selecting
that custom label would not be something you can include in a macro. Also
when you select recipients--use existing list, I don't think that step can
be included in a macro assuming you import a different Excel file for
different mail merges.

I think maybe everything else up to the point of doing the finish &
merge--print documents step can be included in a macro?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default using macros with mailmerge

The whole process can be automated. The easiest way around the custom label
thing (particularly if you have multiple custom labels) would be to create a
template for each on that is already set up with the mergefields in place
and then create a new document from that template.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"biff" wrote in message
...
I am wondering how much I can use macros to take care of steps used in a
mailmerge.

I have an Excel spreadsheet that has column headers and rows of records.
I
want to use the data from that spreadsheet to make labels in Word's
mailmerge.

I know that I have to use a custom size label so I am assuming selecting
that custom label would not be something you can include in a macro. Also
when you select recipients--use existing list, I don't think that step
can
be included in a macro assuming you import a different Excel file for
different mail merges.

I think maybe everything else up to the point of doing the finish &
merge--print documents step can be included in a macro?


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot print document - Macros disabled - no macros! edspyhill01 Microsoft Word Help 3 January 11th 10 07:56 PM
Macros disabled warning in MS Word doc with no macros Earthman Microsoft Word Help 2 December 29th 09 07:17 PM
Mailmerge to Outlook to include Macros in Email Benny_G Mailmerge 3 May 29th 09 01:43 PM
Word & Enable Macros and Disable macros Theresa Microsoft Word Help 1 September 29th 08 10:38 PM
Converting WP merges that use macros to mailmerge/VBA David Evans Mailmerge 1 August 20th 06 05:28 PM


All times are GMT +1. The time now is 12:49 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"