Darrell Bennett wrote:
I have recently upgraded to Windows XP Home Edition from Windows '98.
The Software Package included OpenOffice v.2.0, instead of Microsoft Word and
Microsoft Excel.
I work in Retail and regularly use mailmerge to produce labels etcetera.
I tend to use Excel as a separate database, as this allows me to make single
changes, move cells around to add new lines and to sort the information.
This database is then merged into a Word Document, which I have already set up
and formatted.
However, since getting OpenOffice, I do not seem to be able to merge the same
information into the format I require, and I am having to use OOCalc to produce
the labels, where one cell = one label.
This makes changes extremely time consuming, as each cell has to be formatted
individually and cut and pasted around the sheet to accommodate the new lines.
Is there an easier way to do this?
I have added examples of the Excel Data, the Word Pre-Merge and the Final
Merged Document for clarification.
Any help would be very gratefully appreciated, but please bear in mind that I
am self-taught and not overly computer literate.
Thank You.
Merge Data (Excel):Brand Size Pack Price EpoS
A KS 20 £0.00 1234
B SK 20 £0.00 1235
C KS 10 £0.00 1236
D KS 10 £0.00 1237
E KS 20 £0.00 1238
F SK 20 £0.00 1239
G SK 20 £0.00 1240
H KS 10 £0.00 1241
Pre-Merge Template (Word):<Brand> <Size> <Pack>
<Price>
EPoS: <EPoS>
<Next Record><Brand> <Size> <Pack>
<snip>
Darrell:
I think what you are looking for in OpenOffice.org is what Word calls a
catalog. This is slightly harder in OOo, but still possible.
I suggest you go through the mail merge chapters in the OOo 2.0 users
guide: http://documentation.openoffice.org/manuals/index.html
Then, if you still have questions, let us know what you tried and what
didn't work the way you wanted.
Crystle
--
Crystle Numan
Administrative Secretary, Immanuel CRC
61 Mohawk Rd. W. Hamilton ON L9C 1V9
905-385-0662
[EMAIL PROTECTED]
http://immanuelministries.ca
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
