Mailmerge duplicates 1/6 of database

Issues installing under the Mac OSX - X11 - Aqua
Post Reply
airdrummer
Posts: 12
Joined: Fri Feb 08, 2013 7:36 pm

Mailmerge duplicates 1/6 of database

Post by airdrummer »

i have a wurd doc that i inserted fields from a .csv spreadsheet...this has worked fine in prior years, but this year i found that i got 206 letters printed from 176 lines in the ss...latest aoo4.1.6, wtf?
Attachments
2019mailinglistNoBM.csv
spreadsheet with 176 entries
(16.94 KiB) Downloaded 238 times
2019 Agenda- Proxy.doc
mailmerge doc using spreadsheet
(20 KiB) Downloaded 241 times
aoo4.1.9
osX.15.7
User avatar
MrProgrammer
Moderator
Posts: 4894
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Mailmerge duplicates 1/6 of database

Post by MrProgrammer »

airdrummer wrote: have a wurd doc that i inserted fields from a .csv spreadsheet...this has worked fine in prior years, but this year i found that i got 206 letters printed from 176 lines in the ss
Thank you for the attachments. I am unable to reproduce your problem using the native ODT format instead of your "wurd doc" (DOC format). After pointing a Base document at your CSV file, I used File → Print → Form letter? → Yes which generated 176 documents, the first two of which are attached.
2019 Agenda- Proxy.odt
Form letter in ODT format
(49.01 KiB) Downloaded 230 times
10.odt
First generated document
(48.97 KiB) Downloaded 230 times
20.odt
Second generated document
(48.92 KiB) Downloaded 229 times
[Tutorial] Differences between Writer and MS Word files
Perhaps DOC format does not support Writer fields correctly. ODT format does.

Mail Merge requires a Base document in addition to the CSV data source you provided, and the merge will print what is in Base. You should verify that Base contains 176 records and correct that problem if not. If you're having trouble with Base, we have a separate forum for that component. Another problem where the Base document did not have the expected data was: [Solved] Address Labels
airdrummer wrote:latest aoo4.1.6
Fix your forum signature which says you use the non-existant 3.1.6 version.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
airdrummer
Posts: 12
Joined: Fri Feb 08, 2013 7:36 pm

Re: Mailmerge duplicates 1/6 of database

Post by airdrummer »

thanx, can u attach ur .odt? how did u gen it from the wurd (rhymes with?-)
Attachments
the print/mm dialog screengrabshows 206 recs in odb...
the print/mm dialog screengrabshows 206 recs in odb...
2019mailinglistNoBM0.odb
the .odb that was generated when i linked the csv...it has 176 records
(1.73 KiB) Downloaded 217 times
2019 AgendaProxy2.odt
the .odt i created by copying the .doc, saving as .odt &inserting fields from the .odb
(49.82 KiB) Downloaded 205 times
aoo4.1.9
osX.15.7
airdrummer
Posts: 12
Joined: Fri Feb 08, 2013 7:36 pm

Re: Mailmerge duplicates 1/6 of database

Post by airdrummer »

and here's the output
Attachments
2019 AgendaProxy2Output.odt
the output, 206 letters,
(86.95 KiB) Downloaded 207 times
aoo4.1.9
osX.15.7
User avatar
MrProgrammer
Moderator
Posts: 4894
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Mailmerge duplicates 1/6 of database

Post by MrProgrammer »

MrProgrammer on 06Jan2019 wrote:Form letter in ODT format
airdrummer on 08Jan2019 wrote:can u attach ur .odt?
I did in my previous post. Apparently you didn't read it carefully.
airdrummer wrote:how did u gen it from the wurd (rhymes with?-)
I created Base document so I could access your CSV file. Then I took your bogus Word document which had no actual fields and replaced the placeholders on the second page with Mail Merge fields to the data source. Read about Mail Merge in Help → Index or in User Guides (PDF) or searching for topics about it in the Writer Forum if you don't know how to do that. My Base document had 176 records. My Mail Merge created 176 documents.
MrProgrammer wrote:You should verify that Base contains 176 records and correct that problem if not.
airdrummer wrote:the print/mm dialog screengrabshows 206 recs in odb
You print 206 records because your data source in Base has 206 records. This is shown clearly in your picture.
airdrummer wrote:2019mailinglistNoBM0.odb
I can't open that.
Screen Shot 2019-01-10 at 09.53.31 .png
MrProgrammer wrote:If you're having trouble with Base, we have a separate forum for that component.
You are more likely to find people who can help with this problem in that forum.
airdrummer wrote:a wurd doc
airdrummer wrote:can u attach ur .odt?
airdrummer wrote:how did u gen it
airdrummer wrote:in the ss
Write in clear, grammatical, correctly-spelled language I am done helping here. Bye.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
Post Reply