 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2004Mail Merge from Excel
Hello All, I am using Office XP and have a 100+ Columns worksheet (Master.xls) with Headers in A1, B1......such as Name, LastName, etc etc in and relevant data starting from A2, B2..... I wish to generate about 20+ letters from Master.xls. How can I go about this. I know how to mail merge.. but I was wondering if this process can be automated at click of a button??? Any suggestions would be greatly appreciated TIA Rashid VBA can be used to do all sorts of things, but for what sounds like a simple mail merge, I doubt that it would be worth the effort.  SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Hello All, > I am using Office XP and have a 100+ Columns worksheet (Master.xls) with [quoted text clipped - 12 lines] > > Rashid Hi Doug, Thanks for the prompt reply. Yes I am aware VBA can do wonders .. especailly by all u gurus in the NG. I have created the mail merge files.. but the group of people using are absolutely new to MS Word. Is it possible to make a Master.doc in Word.. when it opens .. it should show about 20 Command Buttons on a Blank Page.. each with the relevant name of the files to be merged.. and when each button is clicked it merges the Data from Master.xls file??? If u can help with something on the above line.. I will be very grateful Thanks again Rashid > VBA can be used to do all sorts of things, but for what sounds like a > simple [quoted text clipped - 17 lines] >> >> Rashid Yes, I would do that with a Userform with a command button on it for each of the files that you want to merge, or a listbox that displays all of the files and then when the user selects the one that they want to merge, they would click on a command button that would open that document and execute the merge. To get started, see the article “How to create a Userform” at: http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm Also, do some browsing through the Visual Basic Help file by typing in things like ActiveDocument.MailMerge and then press F1 to bring up help on the subject. That's how I learnt to do things. SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Hi Doug, > Thanks for the prompt reply. [quoted text clipped - 31 lines] > >> > >> Rashid Hi Doug, Thanks, would give it a go and come back if I am stuck somewhere. Rashid > Yes, I would do that with a Userform with a command button on it for each > of [quoted text clipped - 56 lines] >> >> >> >> Rashid Hi Doug, I visited the link u suggested and thanks to u I learned something new. I searched the NG for approprite code to open a relevant file when the commandbutton is clicked...but did not succeed .. Can u help me with one pls Rashid > Hi Doug, > Thanks, would give it a go and come back if I am stuck somewhere. [quoted text clipped - 64 lines] >>> >> >>> >> Rashid Check out Documents.Open in the Visual Basic Help file. SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Hi Doug, > I visited the link u suggested and thanks to u I learned something new. [quoted text clipped - 73 lines] > >>> >> > >>> >> Rashid ok thanks Rashid > Check out Documents.Open in the Visual Basic Help file. > [quoted text clipped - 91 lines] >> >>> >> >> >>> >> Rashid |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.