Re: [libreoffice-users] Mail Merge Salutation

At 11:39 30/11/2013 -0800, Andrew Brager wrote:
> I'm trying to do a mail merge using the wizard (is there any other 
> way?), and I'm having great difficulty making it do what I need to 
> do.  My data has one field for the name.  A sample name is "Gary L & 
> Judy A Smith".  I simply want it to say "Dear Gary L & Judy A 
> Smith," or even better "Dear Gary & Judy Smith,". I'm unable to 
> accomplish this simple task.  Instead, the best I can come up with 
> is "Dear Mrs. Gary L & Judy A Smith" which is close, but forces me 
> to use a salutation I don't want. Turning off salutations means I 
> don't get the "Dear anything, " which is not what I want either.

I don't see any way to avoid the "Dear" in the automatic salutation, 
but that shouldn't be a problem.  You can drop all sorts of data from 
your database into a mail merge letter, of course: indeed, one 
normally needs to do exactly that, not to send an exact copy of the 
same letter to everyone.  So you can simply select not to have a 
salutation, but then to enter your plain "Dear " and a field for the 
name in the appropriate place in your letter - creating your own salutation.

o Go to Insert | Fields > | Other... | Database.
o Under Type, select Mail merge fields.
o Under Database selection, expand your database and select the name field.

(I think this is part of the answer to your "is there any other way?")

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted