At 15:41 29/07/2016 -0400, Liliane Sklenarik wrote:
I have Open Office 4.1.2 and I use Windows 7. I have been trying to
use Mail Merge. I get to the point where I have registered my data
base (an Excel Spread Sheet). Under the data base file it should
show all the sheets in the file to choose one. I only have 2 sheets.
The active addresses and a Blank sheet I use to print out and hand
write in new addresses when I hold a class. The only sheet that will
show up is the Blank sheet. This sheet shows all the fields (but, of
course, the information in the columns is blank). I can not get the
active sheet with the addresses on it to show up so I can select it.
I have deleted the Blank sheet - then I don't get any sheets to show
up. I have saved the spread sheet as a .xls and as a .ods file. This
has been very frustrating and I have tried to do this for years.
Don't know what to do about it. Please help.
I know little about this, but a little experimentation suggests that
sheets of a spreadsheet will not be recognised by the Address Data
Source... wizard or the database registration process if they do not
appear to be in a suitable format. If, for example, I displace valid
data across or down the sheet by preceding it with blank rows or
columns, the sheet will be disregarded and not appear as a candidate
for data - as you describe.
Have you perhaps arranged your sheet of addresses with titling and
spacing designed to appear as you wish on a printout? Is it that
which has confused the data sources facility into not seeing your
data sheet as a valid table? The Mail Merge facility will generally
be expecting your data source to be simply that: field names in row 1
starting in column A and data in rows 2 onward.
If this is your problem, you may wish to consider this:
o Construct sheets 1 and 2 as you already have - as the two to be printed.
o Select just the actual address data on sheet1, copy it, and paste
it into sheet 3 but using Paste Special instead of ordinary Paste and
ticking the Link option. This will create a copy of the address data
on sheet 3 which will automatically update as you edit sheet 1.
o Add column headings as field names to sheet 3 if necessary.
o Construct print ranges to include both sheets 1 and 2 (but not 3).
Now if you print your document, only sheet 1 and 2 will print. When
using Mail Merge, harvest your data from the new sheet 3.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
