Thank you Cor: your response is much appreciated.
I'll give it a whizz.
Yours aye
Ike Dawson
At 19:05 20/12/2007, you wrote:
Hi Ike,
Ike Dawson wrote (20-12-2007 14:17)
[...] Update to OOo 2.3.1 with an appropriate current document on
screen and entering the Mail Merge Wizard, at 'Step 3 Insert
Address Block' then moving to 3.'1 Select Address List', last years
Calc sheet of NADs is selected and works.
Going 'Add' and navigating to the new NAD source Calc Sheet, I
highlight and hit Open and it appears in the Add Window. However
the OK button to Choose it as the correct source, is greyed out as
indeed are all subsequent items under Steps, i.e. Steps 4 - 8
[...]
Please would some one tell me where I'm going wrong but more
importantly how to put it right?
My approach would be as follows.
- File | New | Database
- Select Connect to existing database
- Choose spreadsheet
- Next
- Select your last years NADs
- Next
- Select Yes, register, Unselect Open the database for editing
- Finish, and give a name to your database file.
Now you have your datasource.
Next is: create document with fields, or labels with fields.
For labels:
- File|New|Labels
For a document:
- open the datasource window (F4);
- select your database;
- add desired fields to your document by drag&drop the headers of
the columns to your document.
When the document/labels is finished:
- start mailmerge:
- click on the mailmerge button (3rd from right in Datasource window)
- or choose Tools|Mail merge wizard
- go directly to step 8.
The datasource can be used for any document.
You can change the spreadsheet behind it. If the window F4 is opene
again, the new data will be there.
You may remove a datasource by rightclicking on the name in the
datasource, and choose Registered datasources.
If you do so, the database file on your system will still be there.
I hope this helps.
Now you don't have to work with the Add option in the mail merge wizard.
Kindest regards.
Cor
--
Cor Nouws
Arnhem - Netherlands
nl.OpenOffice.org - marketing contact
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
No virus found in this incoming message.
Checked by AVG Free Edition. Version: 7.5.503 / Virus Database:
269.17.5/1190 - Release Date: 19/12/2007 19:37
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
