Issue 101997 - Mail merge wizard should 'exchange database' if necessary
Summary: Mail merge wizard should 'exchange database' if necessary
Status: ACCEPTED
Alias: None
Product: Writer
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-05-17 06:55 UTC by jhd21181
Modified: 2017-05-20 11:19 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
mailmergetest.odt (30.99 KB, application/vnd.oasis.opendocument.text)
2009-05-17 07:01 UTC, jhd21181
no flags Details
spreadsheettest.ods (17.59 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-05-17 07:02 UTC, jhd21181
no flags Details
testresultMailMergeodt (42.76 KB, application/vnd.oasis.opendocument.text)
2009-05-17 07:03 UTC, jhd21181
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jhd21181 2009-05-17 06:55:58 UTC
This is my first time sending in an issue.  Please forgive me if I have not sent
it to the right place, and let me know where I can send it.  I use your
OpenOffice Suite 3.0.1 program extensively for seeing my patients in Home
Health, and use the Mail Merge program in MS Word to populate my notes that I
print off or email to my home office.  I would prefer to use your Mail Merge
Wizard in Writer instead.  I have created test odt and ods files which mimic my
spreadsheet and note, but I am not sure how to attach them to this description
so you can run them yourself to see the result.  I would be happy to email them
to you if you like.

Here is the process:
(1) Open the mail merge odt.
(2) Choose Tools, then Mail Merge Wizard.
(3) Choose radio button labeled "Use the current document" and hit Next>>.
(4) Choose radio button labeled "Letter" and hit Next>>.
(5) Choose Select Address List... button.
(6) Under the Select Address List, choose the data base labeled Spreadsheettest
from several data sources listed.
(7) After a moment, under the table column, appears Sheet1.
(8) Next choose the Filter button.
(9) Under Standard Filter, choose Field Name- Date, Condition- like, and Value-
type in 010109.  Then press OK.  Note in this test speadsheet there are only 6
records which match that value.
(10) Back at the Insert address block page I double check to make sure that the
Current address list: is Spreadsheettest.  I then press Next>>.
(11) At the Create salutation page, I press Next>>.
(12) At the Edit document page I press Next>>.  The Mail Merge small screen pops
up and counts off the document 1...2...3..and so forth to 6 of 6.
(12) The Personalize document screen appears and I press Next>>.
(13) The Save, print or send screen appears.  I choose the Save merged document
radio button. A new menu appears below that of Save merged document, and I
choose the radio button Save as a single document, and then press the Save
Documents button.  Type in Testresultmailmerge for the title and save the document.
(4) I press the Finish button.  Next I goto the above file and open it up. No
data has populated the fields, and I have 11 pages (which should have been 6
pages) saved of blank forms.

I would really like to stop using MS products (tired of the blue screen of
death), and use you exclusively.  Let me know what else I can do to help.

I have replicated this same procedure on MS Vista, and Ubuntu 9.04 Linux with
the same results.

Thanks for the great job you do!

Sincerely:

Joel H. Du Mond III, R.N.
jhd1181@yahoo.com
Comment 1 jhd21181 2009-05-17 07:01:02 UTC
Created attachment 62317 [details]
mailmergetest.odt
Comment 2 jhd21181 2009-05-17 07:02:10 UTC
Created attachment 62318 [details]
spreadsheettest.ods
Comment 3 jhd21181 2009-05-17 07:03:14 UTC
Created attachment 62319 [details]
testresultMailMergeodt
Comment 4 amy2008 2009-05-22 08:50:02 UTC
Can confirm it in OOo310m11 on WinXP.
At first, I think if the page layout set as Only Right or Only Left, so the
document has 11 pages, but now I deem it is an bug.
Everyone, would you like giving me a hint?

Set priority as P3, OS as All
Regards
Li Meiying
Comment 5 h.ilter 2009-05-26 13:39:02 UTC
Workaround:
After file opened, define the database first over:
Menu Edit - Exchange Database...
After database is defined, start MailMerge wizard
Btw. You're still able to set the filter within the mailmerge dialog at step3.

The problem with the page number is already present with issue 58919
Comment 6 jhd21181 2009-05-27 05:30:22 UTC
Did the work around.  It worked great.  When I got the point in Mail Merge where
I could edit the generated document, I pressed that button Edit document and
went to the edit mode of the document.  Next went to Print Preview and saw all
of the extra 'blank' pages that showed up in the regular printer setting.  I
found that if I save the document as a PDF file, all the 'blank' pages
disappeared.  Using the PDF format, I could then print and/or email the document
as needed.

Thanks for all of your help:

Joel H. Du Mond III, R.N.
Comment 7 cno 2009-07-10 10:58:54 UTC
@ jhd21181: thanks for your lates comment as well.
Since it does work now, I suggest to close this issue as "Works for me".

But when there is a clear proposal for better work flow / instruction to the
user, we could change it to an Enhancement..
Comment 8 Oliver Specht 2010-02-04 11:46:59 UTC
->cornouws: I wouldn't close it. The wizard should detect that there are
database fields in the document that need to be assigned to the new data source. 

Changed target to OOo later, changed summary, was: "Mail Merge won't populate
fields from Speadsheet data."
Comment 9 Marcus 2017-05-20 11:19:32 UTC
Reset assigne to the default "issues@openoffice.apache.org".