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 <[email protected]>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: [email protected] > 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: [email protected] 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
