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: [email protected] 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
