 |
 | 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 / June 2004excel interfacing
hello all... i have a long excel spreadsheet with lots of customers info on it, i have a userform which picks out userdefined info from cells, so their address will be stored under an address string. is there anyway i can export this info to a word document, ie into an address field in a mail merge. I'm new to all of this mail merging, is there a way to do this without specifying a source for the data, or overriding it to put in my own. Thanks for any help you can give me. Paul Haughton Is the userform in Excel or Word? Do you just want to create one letter at a time, or one letter for each customer?  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... > [quoted text clipped - 12 lines] > > Paul Haughton The userform is in excel and all i need to do is create one letter at a time. It is a modeless userform so the user can click on the relavent cell to get the info from excel, but if the info is missing they can fill the field themselves. The main problem i have is exporting all of this information in to a word document, setting the template up and all the excel bits are fine, it's just this middle bit i'm stuck with. TIA Paul >-----Original Message----- >Is the userform in Excel or Word? [quoted text clipped - 20 lines] > >. I would be more inclined to have the userform in Word. See the article "Load a ListBox from a Named Range in Excel using DAO" at: http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm Then when the user selects an item (record) in the listbox, you could have a series of textboxes on the userform populated with the data for that record and they could enter the missing data into the textboxes and then click on a command button that would either insert the information from the textboxes into (InsertBefore) the range of bookmarks that you place in the template, of load the information into document variables so that it is displayed in document variable fields that you place in the template. See the article "How to create a Userform" at: http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm 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 > The userform is in excel and all i need to do is create > one letter at a time. It is a modeless userform so the [quoted text clipped - 50 lines] > > > >. Hi Paul, You should find an article that describes how to run Word from within Excel, and dump data into a document on word.mvps.org > The userform is in excel and all i need to do is create > one letter at a time. It is a modeless userform so the [quoted text clipped - 6 lines] > up and all the excel bits are fine, it's just this middle > bit i'm stuck with. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
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.