Issue 70581

Summary: Mail Merge Wizard empty inactive Mail merge fields, they are linked to the second inactive database
Product: Writer Reporter: matthias54654 <forum>
Component: printingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 2.0.4   
Target Milestone: ---   
Hardware: All   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
The User database Source
this is a piece of the main database for example
this is a mail merge document for example none

Description matthias54654 2006-10-19 03:13:12 UTC
If you use mail merge fields for 2 different databases in one document, make the
mail merge wizard the fields, which linked to the second database, empty. The
normal Serialprint, getting with STRG+P, print the existing value, thats the
right way. The second database need i for quick userchange in one document. My
user-database have many fields within Bank account, Tax number and much more for
all sender information u need. My Files cant be used in the mail merge wizard.

Please make that the mail merge wizard ignore all mail merge fields wich are
linked to a second inactive database.

Thank you.

Matthias Pester

My first Staroffice was Staroffice 3.1, my last Staroffice was Staroffice 7.0, i
am a Staroffice-User.
Comment 1 eric.savary 2006-10-19 13:31:55 UTC
Reassigned to Requirements
Comment 2 eric.savary 2006-10-19 13:32:25 UTC
Reassigned to HI
Comment 3 h.ilter 2006-10-19 14:01:55 UTC
That won't be easy as long as only one databse can be defined to a document.
Set to Enhancement.
Comment 4 matthias54654 2006-10-19 14:49:26 UTC
>> That won't be easy as long as only one databse can be defined to a document.
Set to Enhancement.

My Answer:
The Mail Merge wizard work in a other way as the serial print wizard, thats the
one with the litte small window, and the one which print files with a filename
taking from database. Open a Merge document and press cntrl+P to and say yes to
get the primary mail merge wizard.

The New mail marge wizard do it wrong and use more than one database.

With the old one u can have many databases in one document and only one is
active, thats the right way, for mail merge everybody need only one active database.

But for the document usability u need 2 databases, one for the sender and one
for the receiver. The Database of the sender is only active when u change the
sender. If u have changed the sender, u must change the receiver database, to
set the receiver database as active database for the document. To change the
database, go to Edit>> Exchange Database, close there the user database and
select the receiver database and select on the right side also the receiver
database, and click at "Define". The active database is now the receiver
database and the values in the fields of the sender database should be ignored
by the mail merge wizard. But the new creation of mail merge wizard empty the
fields of my sender database. I hope u can understand me now better, because u
have me misunderstood before.

The primary merge wizard in 2.0.4 can this what i want, and the new one isn´t
able, thats the problem. Therefore i say it isn´t difficult to kill this error
of the new buildet mail merge wizard. (The all wizard, creation and using).

Ill tell u this because i want not that u go in a wrong way in future.

Furthermore i need a personalized Subject from database (like the email address
is taking from database), for "send merged document as email".

Thank you for creation a Free Office application. I want help you to make a
better one.
Matthias Pester
Comment 5 matthias54654 2006-10-23 22:37:35 UTC
Created attachment 40007 [details]
The User database Source
Comment 6 matthias54654 2006-10-23 22:40:54 UTC
Created attachment 40008 [details]
this is a piece of the main database for example
Comment 7 matthias54654 2006-10-23 22:41:50 UTC
Created attachment 40009 [details]
this is a mail merge document for example
Comment 8 matthias54654 2006-10-23 22:45:43 UTC
1. create databases with the spreadsheets
2. exchange both tatabases, exchange the user database first time and the main
database second time.

See it self what the new mail merge wizard with the inactive mailmerge fields make.

Matthias Pester

PS: the mail merge document is not ms word....this is only my error while taking
the upload wizard.