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

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