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

That's the problem. Whenever I attempt to do the mail merge, it doesn't
list any of the custom fields in my document. It only list "canned" fields.
I don't see how I can match my existing fields within this interface.

[image: Inline image 2][image: Inline image 1]


-----
Jeff Prater


On Wed, Mar 19, 2014 at 4:43 PM, Don C. Myers <donmyers@myersfarm.com>wrote:

> Hi,
> I did my database in OO about 10 years ago, maybe more. I haven't fiddled
> with the fields since then, but they were custom fields. I moved to LO as
> soon as it was released. I use mail merge extensively, and had no problems
> having custom named fields working to pull the data from. So there should
> still be someway to do it.
> Don
>
>
> On 03/19/2014 04:12 PM, Jeff Prater wrote:
>
> > 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
> --
>
> *~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
> Don C. Myers
> Manager, Farm and Rural Property Division
> e-PRO Certified by the National Association of Realtors
> Don's Cell Phone: 814-571-9518, Don's Home Phone: 814-422-8111
> Don's E-mail: donmyers@myersfarm.com <mailto:donmyers@myersfarm.com>
> *RE/MAX Centre Realty
> **1375 Martin Street, State College, PA 16803*
> Office Phone: 814-231-8200 Fax: 814-231-8220
> Visit the Farm and Rural Property Division web site at _
> www.CentralPaRuralProperty.com <http://www.CentralPaRuralProperty.com/> _
> Visit the RE/MAX Centre Realty main web site at _
> www.StateCollegeHomeSales.com <http://www.statecollegehomesales.com/> _
> View Don's Farm Web Site at www.myersfarm.com <http://www.myersfarm.com/>
> *~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
>
>
>
> --
> 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