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 <donmy...@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.edmo...@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+unsubscr...@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: donmy...@myersfarm.com <mailto:donmy...@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+unsubscr...@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+unsubscr...@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