In the good old days you output a CSV file from the database and the WP imported it and read it, putting the field into a form letter.
I think this question should have been directed at Microsoft since it is bemoaning the inadequacies of their products. However, I bet someone gives a useful answer.
Since CSV is a Microsoft format I would expect Word to use such files as sources of mailmerge information. Therefore it is to the Word manual you should turn for help, in my humble opinion ;)
You can export your records from Cardbox formatted as letters (to be opened in MS Word), using File-transfer-write, and choosing .PRN in the "List conversion types" dialog box.
Alternatively, if you need your letters in hard copy - you may eliminate the MS Word step and print them directly from Cardbox.
In order to export records in form letters, you must
You may design letters formatted exactly as your letterhead, including logos, special fonts, etc., or letters configured so that they can be printed on your stationary.
You may design the format, so that you print one letter for each record, or a list of records in a letter.
If you have any additional questions or need help designing a form letter I will be happy to help. You may contact me off list at by e-mail at firstname.lastname@example.org or by telephone at 905-884-9320
.csv format is a comma delimited format used as the export format by Excel.
You can export your Cardbox records in "comma delimited" format if you choose .TXT in the "List conversion types" dialog box.
Searching in Google for
"word 2003" mail-merge csv
gives a number of useful references.
The first is http://www.tucsonrealtors.org/mailmerge.pdf - a step-by-step guide to mail-merging in Word 2003, using CSV files among others.
The second is a link from Microsoft that clearly says that Word 2003 *can* use CSV files as a data source - http://support.microsoft.com/ph/2530/en-us/?sid=47&aid=3&GSA_AC_More3.
Later links in the same Google search give more detailed instructions.
In my opinion, you will get a better format layout using the mailmerge facility in word.
Choose mailing / start email merge
1 - Choose type of mailmerge letter / email etc
CSV isn't a 'Microsoft' format, it's an open format, standing for Comma Separated Values, but you will find lots of useful information in the Word help files.
DDE, which is often overlooked, is also worth taking a look at it, Cardbox has great support for it.
Thanks all for the advice. Having 20 years ago, wrestled with Mailmerge it is clear that very little has changed. Frankly the Cardbox manual is very unhelpful for both internal mailmerge and external with Word etc, which I find all a bit strange because Databases are not a lot of use unless they interface with something!
With regard to Iuliana "CSV is not an option from cardbox" If I select a file and then export it, my version of Cardbox gives it as the first option, and which is exactly the same as far as I can see from the old "comma delimited format" which we used to use in the good old days of the Z80. I certainly works fine with Word 2003, as long as you steer clear of any Microsoft databases, and select the data file via browse
|© 2010 Cardbox Software Limited|