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>
<Price>
EPoS: <EPoS>
<Next Record><Brand> <Size> <Pack>
<Price>
EPoS: <EPoS>
<Next Record><Brand> <Size> <Pack>
<Price>
EPoS: <EPoS>
<Next Record><Brand> <Size> <Pack>
<Price>
EPoS: <EPoS>
<Next Record><Brand> <Size> <Pack>
<Price>
EPoS: <EPoS>
<Next Record><Brand> <Size> <Pack>
<Price>
EPoS: <EPoS>
<Next Record><Brand> <Size> <Pack>
<Price>
EPoS: <EPoS>
Merged Document (Word):A KS 20
£0.00
EPoS: 1234
B SK 20
£0.00
EPoS: 1235
C KS 10
£0.00
EPoS: 1236
D KS 10
£0.00
EPoS: 1237
E KS 20
£0.00
EPoS: 1238
F SK 20
£0.00
EPoS: 1239
G SK 20
£0.00
EPoS: 1240
H KS 10
£0.00
EPoS: 1241
