Mailmerge duplicates 1/6 of database
-
- Posts: 12
- Joined: Fri Feb 08, 2013 7:36 pm
Mailmerge duplicates 1/6 of database
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 257 times
-
- 2019 Agenda- Proxy.doc
- mailmerge doc using spreadsheet
- (20 KiB) Downloaded 255 times
aoo4.1.9
osX.15.7
osX.15.7
- MrProgrammer
- Moderator
- Posts: 4908
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Mailmerge duplicates 1/6 of database
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. [Tutorial] Differences between Writer and MS Word filesairdrummer 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
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
Fix your forum signature which says you use the non-existant 3.1.6 version.airdrummer wrote:latest aoo4.1.6
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).
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).
-
- Posts: 12
- Joined: Fri Feb 08, 2013 7:36 pm
Re: Mailmerge duplicates 1/6 of database
thanx, can u attach ur .odt? how did u gen it from the wurd (rhymes with?-)
- Attachments
-
- 2019mailinglistNoBM0.odb
- the .odb that was generated when i linked the csv...it has 176 records
- (1.73 KiB) Downloaded 232 times
-
- 2019 AgendaProxy2.odt
- the .odt i created by copying the .doc, saving as .odt &inserting fields from the .odb
- (49.82 KiB) Downloaded 233 times
aoo4.1.9
osX.15.7
osX.15.7
-
- Posts: 12
- Joined: Fri Feb 08, 2013 7:36 pm
Re: Mailmerge duplicates 1/6 of database
and here's the output
- Attachments
-
- 2019 AgendaProxy2Output.odt
- the output, 206 letters,
- (86.95 KiB) Downloaded 227 times
aoo4.1.9
osX.15.7
osX.15.7
- MrProgrammer
- Moderator
- Posts: 4908
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Mailmerge duplicates 1/6 of database
MrProgrammer on 06Jan2019 wrote:Form letter in ODT format
I did in my previous post. Apparently you didn't read it carefully.airdrummer on 08Jan2019 wrote:can u attach ur .odt?
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.airdrummer wrote:how did u gen it from the wurd (rhymes with?-)
MrProgrammer wrote:You should verify that Base contains 176 records and correct that problem if not.
You print 206 records because your data source in Base has 206 records. This is shown clearly in your picture.airdrummer wrote:the print/mm dialog screengrabshows 206 recs in odb
I can't open that.airdrummer wrote:2019mailinglistNoBM0.odb
You are more likely to find people who can help with this problem in that forum.MrProgrammer wrote:If you're having trouble with Base, we have a separate forum for that component.
airdrummer wrote:a wurd doc
airdrummer wrote:can u attach ur .odt?
airdrummer wrote:how did u gen it
Write in clear, grammatical, correctly-spelled language I am done helping here. Bye.airdrummer wrote:in the ss
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).
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).