Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA+Doing MailMerge with Excel (Off97)
I need help or guide on how to make excel do mailmerging.
I read a book but nothing on that. I tried to make Word to do mailmerge using data on excel. I called Word (Object) via Excel but whenever Word tried to read data on th activesheet it just stopped. sometimes it hung. tried to the same o diff pc, same result. I have about 1000 lines with about 14 fields/columns. Some fields wil be taken to mailmerge; meaning there'll be 1000 prints/report. Really appreciate any help on this. Hope the problem is clear enough. Thanks for the help -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA+Doing MailMerge with Excel (Off97)
I don't know about using MailMerge from VBA, but
Mail Merge uses the first sheet in the Excel workbook, not the activesheet, so you will certainly encounter difficulty there. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "joelx " wrote in message ... I need help or guide on how to make excel do mailmerging. I read a book but nothing on that. I tried to make Word to do mailmerge using data on excel. I called Word (Object) via Excel but whenever Word tried to read data on the activesheet it just stopped. sometimes it hung. tried to the same on diff pc, same result. I have about 1000 lines with about 14 fields/columns. Some fields will be taken to mailmerge; meaning there'll be 1000 prints/report. Really appreciate any help on this. Hope the problem is clear enough. Thanks for the help. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA+Doing MailMerge with Excel (Off97)
OK... thanks for the info.
Let's change the way i'm going to do it. How about... after my excel macro done its thing, it calls Word, not b object though, and I will set it to call a saved word document togethe with execution of Word. This was I can make Word macro automatically run and find data on th excel xls and do mail merge from there. I tried to do this by using object but macro just doesn't run tha way. Perhaps there is a function to call external command that I don't kno of...? Again I appreciate any help. Thanks -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I perform mailmerge in Excel | Excel Discussion (Misc queries) | |||
Excel Word - Mailmerge | Excel Discussion (Misc queries) | |||
can i use mailmerge to in excel like you would in word? | Excel Discussion (Misc queries) | |||
Mailmerge Master for use with Excel database | Excel Discussion (Misc queries) | |||
VBA mailmerge from Excel | Excel Programming |