Mailmerge duplicates 1/6 of database

Issues installing under the Mac OSX - X11 - Aqua

Mailmerge duplicates 1/6 of database

Postby airdrummer » Sun Jan 06, 2019 5:45 am

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 46 times
2019 Agenda- Proxy.doc
mailmerge doc using spreadsheet
(20 KiB) Downloaded 41 times
aoo4.1.6
osX.11.6
airdrummer
 
Posts: 5
Joined: Fri Feb 08, 2013 7:36 pm

Re: Mailmerge duplicates 1/6 of database

Postby MrProgrammer » Mon Jan 07, 2019 3:05 am

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 41 times
10.odt
First generated document
(48.97 KiB) Downloaded 41 times
20.odt
Second generated document
(48.92 KiB) Downloaded 41 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.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3741
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Mailmerge duplicates 1/6 of database

Postby airdrummer » Wed Jan 09, 2019 4:53 am

thanx, can u attach ur .odt? how did u gen it from the wurd (rhymes with?-)
Attachments
2019 AgendaProxy2mmDialog.jpg
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 33 times
2019 AgendaProxy2.odt
the .odt i created by copying the .doc, saving as .odt &inserting fields from the .odb
(49.82 KiB) Downloaded 33 times
aoo4.1.6
osX.11.6
airdrummer
 
Posts: 5
Joined: Fri Feb 08, 2013 7:36 pm

Re: Mailmerge duplicates 1/6 of database

Postby airdrummer » Wed Jan 09, 2019 6:40 am

and here's the output
Attachments
2019 AgendaProxy2Output.odt
the output, 206 letters,
(86.95 KiB) Downloaded 34 times
aoo4.1.6
osX.11.6
airdrummer
 
Posts: 5
Joined: Fri Feb 08, 2013 7:36 pm

Re: Mailmerge duplicates 1/6 of database

Postby MrProgrammer » Thu Jan 10, 2019 6:27 pm

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.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3741
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Mac OSX

Who is online

Users browsing this forum: No registered users and 3 guests