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

Yeah--I guess I could do that. But I already have all these fields created.
I have probably 50+ documents where I would need to make these manual
changes. Plus, the spreadsheets get updated regularly and I don't want to
have to reimport/reattach the spreadsheet all the time. I guess I'll have
to stick with Lotus Symphony. :(


-----
Jeff Prater


On Wed, Mar 19, 2014 at 3:22 PM, Steve Edmonds
<steve.edmonds@ptglobal.com>wrote:

> 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

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