Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-22-2018, 07:27 PM
Jshopping Jshopping is offline Windows XP Office 2003
Novice
 
Join Date: Jan 2011
Location: NYC
Posts: 17
Jshopping is on a distinguished road
Default Export .csv file to Word for Mail Merge?

Iím using an old DOS database software called Q&A 4.0 that Symantic had abandoned in the late 90ís. Yes, I know it obvious that I should just switch to a new database, but Iíd rather not go into why I want to stay with this progam.

It works fine for my small business as I just input text into fields after phone calls and when a job is booked, but since USB printers came out, Iíve had to ďtrickĒ the computer to print to USB using the LPT1 port thatís in the program. I print an average of 25 invoices each month.

So far, this has always worked fine in Windows XP, but Windows 10 doesnít allow me to run the program, and Windows 7 just barely allows the printing trick to work, and its working less and less in Windows 7. I have to keep rebooting the computer to test if I can print.

I am able to export data for this DOS program as a .csv file as I do this to make labels for the envelopes using Avery Label Pro, so I thought of an idea, but had a question about it.

My question is this. Can I export the name, address and the other fields showing time/date of service and the amount of money Iím charging for the job, and then merge the data into Word documents to produce 25 separate invoices?



Any help would be greatly appreciated.

Thanks
Jerry
Reply With Quote
  #2  
Old 09-22-2018, 10:03 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,702
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

Duplicate post at https://answers.microsoft.com/en-us/...1-86e1b05b3b61
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 09-22-2018, 10:26 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,191
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Provided Word can query the database using one of the available connection methods, you shouldn't have to export anything from it to CSV.

For the cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #4  
Old 09-22-2018, 11:04 PM
Jshopping Jshopping is offline Windows 7 32bit Office 2016
Novice
 
Join Date: Jan 2011
Location: NYC
Posts: 17
Jshopping is on a distinguished road
Default

Sorry about the cross post. I don't even know how I did that, and I'm now going to find the duplicate one and delete it.
Reply With Quote
Reply

Tags
.csv, dos, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Word VBA to save Word doc to separate PDF files using a Mail Merge field as File name meghanquint4 Word VBA 2 02-28-2018 07:12 AM
converting a word document to a data file for mail merge drsuis Mail Merge 4 02-21-2013 03:34 PM
Word Mail Merge File Save mickeyw3340 Mail Merge 2 12-18-2012 11:30 AM
Mail Merge--different connections of Access in Single Word File. Goldenbird Mail Merge 3 06-12-2009 06:42 AM
Outlook e-mail addresses Export to a CSV file ronb Outlook 1 03-24-2009 07:45 AM


All times are GMT -7. The time now is 01:45 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft