Re: [libreoffice-users] Mail merge with custom fields in LibreOffice 4.2

On 2014-03-20 07:12, Jeff Prater wrote:
> At my job we currently use Lotus Symphony and we use the Open Document
> format exclusively. We're currently in the process of migrating to
> LibreOffice 4.2. We have a lot of documents we use with the mail merge
> feature. All of the data sources are from spreadsheets. In Symphony, the
> spreadsheet column names are automatically mapped to the field names in the
> text document. In LO, however, it seems it only wants to default to
> "standard" mail merge fields (first name, last name, address line 1, city,
> state, zip, etc.). I would have to remap every field to match LO's field
> naming convention. I don't want to have to do that. How can I make this
> more like Symphony's mail merge functionality where LO matches the column
> name with the field name? I'm not merging letters--I'm merging data from a
> spreadsheet using custom column names (like AmountPosted, JobID,
> DateCreated, DateCompleted, etc.). Thanks!
>
> -----
> Jeff Prater
Hi.
I merge spread sheet data into documents that a printed (certificates). 
I started by creating the certificate in writer, just as I want it to 
look with dummy information. Then to replace the dummy information from 
a spread sheet I Insert>Field>Other (ctl-F2). Select the database tab, 
mail merge fields and under the right pane Add database file - Browse. I 
locate my spread sheet which will appear in the right pane and allow you 
to select the field you want.
Note that this copies the sheet to an odb file and inserts from that 
file. If you update your spread sheet the odb file is not automatically 
updated.
Steve


--
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