Page 1 of 1

Mailmerge duplicates 1/6 of database

PostPosted: Sun Jan 06, 2019 5:45 am
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?

Re: Mailmerge duplicates 1/6 of database

PostPosted: Mon Jan 07, 2019 3:05 am
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 25 times
10.odt
First generated document
(48.97 KiB) Downloaded 25 times
20.odt
Second generated document
(48.92 KiB) Downloaded 25 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.

Re: Mailmerge duplicates 1/6 of database

PostPosted: Wed Jan 09, 2019 4:53 am
by airdrummer
thanx, can u attach ur .odt? how did u gen it from the wurd (rhymes with?-)

Re: Mailmerge duplicates 1/6 of database

PostPosted: Wed Jan 09, 2019 6:40 am
by airdrummer
and here's the output

Re: Mailmerge duplicates 1/6 of database

PostPosted: Thu Jan 10, 2019 6:27 pm
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.