Immanuel CRC Office wrote:
CarlP wrote:
G. Roderick Singleton wrote:
On Tue, 2006-03-14 at 12:59 -0500, CarlP wrote:
.mer is a file type that is a special csv file type export option by
Filemaker Pro (6 and earlier) that contains field names (a straight
csv export by FMP for some reason doesn't include field names).
This file type is readily used by M$Word and other M$ software as a
data source for mail merges.
Some time ago I asked about how to use .mer files directly as an OO
data source but thus far haven't found a way to do so without
jumping through a number of hoops. If I can't use it directly for
mail merges, then I'd at least like to force OO to use Calc to open
this file type. Instead, it opens with Writer, and I can't find a
setting to make it open in Calc. BTW, if I simply change the
extension to csv, it opens fine in Calc. But I don't want to have
to do this every time I create a new data source and mail merge.
Sorry, I do not understand. Are you saying that selecting Text CSV in
the file type drop down for open is failing or that you haven't tried
it? I ask because it works for me.
Sorry for the confusion. CSV opens fine for me. What I want to do is
force OO to use Calc when it opens a file of type .mer instead of
Writer (this is the special csv file type I mentioned above).
Hope this helps,
Carl
Carl:
When you are in Calc, do File->Open. Select your .mer file. Then in the
Type box, select Text CSV. This will open it properly.
Crystle
One more thing. When I take the same .mer file (associated or not) and
use Crystle's suggestion, but use the "Open Document Spreadsheet" file
type instead of the "Text CSV" type, the file also opens in Writer, not
Calc. This untuitively seems wrong to me, but I'm sure I'm missing
something in how the File Type option is supposed to work. Can anyone
fill me in on this?
Carl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
