 |
 | 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 / November 2004Mailmerge with csv files
Should I be able to create mailing labels by using a csv file as the datasource in Word 97 SR-1 Regards & TIA Yes  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Should I be able to create mailing labels by using a csv file as the > datasource in Word 97 SR-1 > > Regards & TIA Thank you Graham, ... I thought as much ... I have set up the files on one machine using Word 97 but when I copy them to another machine using Word 97 SR-1 I cannot make the files merge. Do you think a re-installation of the Office would help ? Regards Jim Burton > Yes > > > Should I be able to create mailing labels by using a csv file as the > > datasource in Word 97 SR-1 > > > > Regards & TIA I would think it extremely unlikely that a re-install would do anything useful. What exactly happens? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thank you Graham, ... I thought as much ... I have set up the files > on one machine using Word 97 but when I copy them to another machine [quoted text clipped - 18 lines] >>> >>> Regards & TIA Well ... Nothing happens really. I get a dialog box saying datasource can't be found ... I then use the option to remove the datasource / headings Then I try to open a datasource via the mailmerge menu and select all files (i.e. *.*) When I highlight the datasource (a .csv file) it does not appear in the filename box In fact come to think of it neither did a word document that I highlighted in error > I would think it extremely unlikely that a re-install would do anything > useful. What exactly happens? [quoted text clipped - 21 lines] > >>> > >>> Regards & TIA Hmmm. Open the csv file in word. Use table > convert text to table and create a Word table. Save as a Word document and see if that will work as a data file. Re-run Word setup from control panel > add & remove programs and ensure that all the text conversion filters are installed. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Well ... Nothing happens really. > I get a dialog box saying datasource can't be found ... [quoted text clipped - 40 lines] >>>>> >>>>> Regards & TIA I will try your second suggestion first ... but unfortunately I will not be able to do so until Monday at the earliest and most probably it will be a week from today. I am somewhat like a one eyed man in the kingdom of the blind. (Thank goodness for newsgroups and MVPs) The Background .... I was asked, by a friend, to create the mailmerge routine using vba to manage a simple database of 2,000 records and using by using vba and automation, print mailing labels, based on various criteria. It all worked fine (at home) using csv files as a datasource until I installed it at my friends restaurant...... and it still works here at home. Regards and thanks again Jim Burton > Hmmm. Open the csv file in word. Use table > convert text to table and > create a Word table. Save as a Word document and see if that will work as a [quoted text clipped - 47 lines] > >>>>> > >>>>> Regards & TIA |
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.