On 19-May-10 22:14, Liliane Sklenarik wrote:
Hello,
I have a data base of clients on an Excel Spread Sheet. There are 3
sheets - ACTIVE, ARCHIVE and BLANK. When I try to set up a MAIL
MERGE, I can get to my data source, but the only sheet I am able to
select is BLANK (and as the name suggests...it is a blank table for me
to hand write in new client data as new clients come into my office).
I wish to use the ACTIVE sheet, but no matter what I do, I can not see
it or select it in MAIL MERGE (or INSERT ENVELOPE). I have read many
tutorials on this subject and can not see what I am doing wrong.
(Interesting note: The first time I tried to set up a MAIL MERGE (4
months ago), I successfully did it and saved the file to use again
next month...since that first time, I have never been able to select
my ACTIVE page!)
LS
Maybe you've solved that by now, but maybe this will help.
If you do a mail merge with a spreadsheet as your source, OpenOffice.org
creates a database in Base from that spreadsheet. It's not apparent
that has been done but the data for the mail merge is actually in a Base
document, not your spreadsheet; it means that changes in your
spreadsheet will not appear in your mailing list. Every time you want
to do a mailing (if the list has changed) you should save the
spreadsheet under a new name and create your mailing list from that new
spreadsheet.
Assuming you're doing your mailing in OOo Writer, you can select the new
spreadsheet by choosing "Exchange database" from the "Edit" menu.
Troll/Idiot
Have a nice day.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
