If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|