 |
 | 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 2005Can't find "Microsoft Excel Worksheet Via Converter" as data sourc
I have a user who used to use Word to merge to very large excel files and when selecting data source had to select Microsoft Excel Worksheet Via Converter as datasource type. Since upgrading to Office 2003 we do not have that option any longer. I have made sure that all filters and converters are installed. I have also installed the converter pack for 2003 and still do not have this option. The reason my user has used this datasource type is it prevents a problem with very large merges to envelopes messing up the addresses. The merge goes along fine for so long and then then all of a sudden the city, state and zip from one of the addresses starts to print on the remaining addresses in addition to the address that prints. So in other words, we have addresses that have 2 cities, 2 states and 2 zips. Example: Name Street Sherburne, NY 13460 Earlville, NY 13332 Splitting these populations up so that the run is shorter each time does not work. We have tested this with Excel and DDE types for .xls and neither work. Merging MS Word to .xls spreadsheets. I would welcome any suggestions on how to deal with this. We have Windows XP SP2 -- Office 2003 SP1 Joelle Faulks From the Tools menu, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. After doing that, when you attach the data source, you will be presented with a number of options for the way in which the connection to the data source will be made. Maybe one or the other of those will overcome your problem.  SignatureHope 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 >I have a user who used to use Word to merge to very large excel files and > when selecting data source had to select Microsoft Excel Worksheet Via [quoted text clipped - 29 lines] > We have Windows XP SP2 -- Office 2003 SP1 > Joelle Faulks Or maybe grab the old converter via the link from my web site http://www.gmayor.com/downloads.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > From the Tools menu, select Options and then go to the General tab > and check the box against the "Confirm conversions at open" item. After [quoted text clipped - 36 lines] >> We have Windows XP SP2 -- Office 2003 SP1 >> Joelle Faulks Hi Graham, Thank you for your speedy reply. I downloaded the one I thought should do the trick and "Excel Converter for Word" and unzipped the file and inserted it into the directory it asked me to. I then tried it and do not find the "Microsoft Excel Worksheet Via converter" as an option. Do I need to do anything more? Or perhaps I have the wrong file? The name of the file is excel32. The other option that Doug gave me didn't give me any more options than I had before. None of them worked previously. I have already tried the Office Converter Pack that you have as the Supplementary filter Packs link. Joelle > Or maybe grab the old converter via the link from my web site > http://www.gmayor.com/downloads.htm [quoted text clipped - 39 lines] > >> We have Windows XP SP2 -- Office 2003 SP1 > >> Joelle Faulks You will have to close and restart Word to activate the filter, then if you have the confirm conversions at open option selected - the Microsoft Excel Worksheet Via converter option should be available. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi Graham, > [quoted text clipped - 63 lines] >>>> We have Windows XP SP2 -- Office 2003 SP1 >>>> Joelle Faulks Hi Graham, Well, I can see converters -- I hadn't selected show all before -- she is still not seeing the one she wanted. We tried a few others. In the conversation I find that she is using a database that comes from Crystal Reports that she puts into Excel and then merges with Word. I had her try the OLE DB Database file option and it seemed to work for her. For now anyway. I am wondering if there is a better way to merge directly from the Crystal Reports file without having to do the Excel step. Joelle > You will have to close and restart Word to activate the filter, then if you > have the confirm conversions at open option selected - the Microsoft Excel [quoted text clipped - 67 lines] > >>>> We have Windows XP SP2 -- Office 2003 SP1 > >>>> Joelle Faulks Depending on the operating system she may have to reboot before the filter becomes available. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi Graham, > [quoted text clipped - 88 lines] >>>>>> We have Windows XP SP2 -- Office 2003 SP1 >>>>>> Joelle Faulks No such luck. :-( > Depending on the operating system she may have to reboot before the filter > becomes available. [quoted text clipped - 91 lines] > >>>>>> We have Windows XP SP2 -- Office 2003 SP1 > >>>>>> Joelle Faulks |
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.