[libreoffice-users] Re: Problem with Mail Merge

2011-09-01 Thread thomasjk
I recommend this excellent article on Mail Merge http://www.freesoftwaremagazine.com/articles/mail_merge_openoffice_org Mail Merge in Openoffice . - Tom K. -- View this message in context: http://nabble.documentfoundation.org/Problem-with-Mail-Merge-tp3299642p3301786.html Sent from

[libreoffice-users] More mail merge help needed

2013-08-14 Thread Carl Paulsen
I'm trying to create mail merge documents that contain merge fields for a document that can't connect directly to the data source. That source (Salesforce) can read the documents if the field names are correctly entered. I can type the field names in manually, but I can't figure out how

Re: [libreoffice-users] More mail merge help needed

2013-08-15 Thread Paul D. Mirowsky
I am not an expert, but I do have a question. Does Salesforce have a database connector that will allow you to use LibreOffice Base as an intermediary to your Writer document? Paul On 8/14/2013 1:35 PM, Carl Paulsen wrote: I'm trying to create mail merge documents that contain merge fields

Re: [libreoffice-users] More mail merge help needed

2013-08-22 Thread Steve Edmonds
Hi. Are you wanting to upload this document as a template for a SF extended mail merge. Do you need this document in .doc format (seems so from my quick look at SF instructions). Steve On 2013-08-23 13:48, Carl Paulsen wrote: Thanks, Paul. I've been away for a bit. There is a LO connector

Re: [libreoffice-users] More mail merge help needed

2013-08-22 Thread Carl Paulsen
Thanks, Paul. I've been away for a bit. There is a LO connector for SF, but AFAIK that connector won't make a merge document work within the broader Force.com platform. But this may be worth looking into further. I'm still stuck on creating the document with next record and next page fields

[libreoffice-users] Mail merge manual field entry

2013-08-12 Thread Carl Paulsen
Hi all, I need to create a mail merge that will, I hope, be used with Salesforce for mail merge communications. I need to create a document with manually entered merge fields where the source database has not (and probably can not - at least with my current skills) be registered

[libreoffice-users] Re: Does Libre Office have merge codes?

2011-09-18 Thread Andreas Säger
Am 18.09.2011 17:41, AMCooper63 wrote: Merge fields are only the beginning. I found those. What I need is the ability to use code to do things with the data in the mail merge. I found conditional fields. But that isn't enough yet. I need to be able to do things like I described in the first

[libreoffice-users] Help with Mail Merge

2017-08-29 Thread alice.gio
Hi everybody! I have a problem with mail merge on Libre office 5.3 installed on Ubuntu 16.04. Once I inserted every field, the function I can't perform Merge Mail on a selected record. I tried on other PC and it appear the option . I disinstalled and reinstalled all the Libre Office package

Re: [libreoffice-users] Mail Merge question

2021-05-26 Thread Robert Großkopf
Hi Suzie, > Can anybody > tell me how to insert mail merge fields one at a time, and not just > the standard address block that’s in the mail merge wizard? In Writer try Insert → Field → More Fields → Database → Type → Mail Merge Fields and select the field from the table of your

[libreoffice-users] Mail Merge question

2021-05-26 Thread Suzie Reedy
I am trying to do a mail merge and I have a “Salutation” field in my database because each of my salutations are different. Can anybody tell me how to insert mail merge fields one at a time, and not just the standard address block that’s in the mail merge wizard? Thanks. Suzie M. Reedy

[libreoffice-users] Mail Merge Label Problem

2023-04-11 Thread Matt Brown
Good day, We are trying to generate labels from the Mail Merge component of Libreoffice 7.2. We can work through the mail merge system however for some reason the Mail Merge can't locate a Database to pull the contact information from. Is there someone we can talk with directly to help us

Re: [libreoffice-users] Mail merge manual field entry

2013-08-12 Thread Carl Paulsen
A related question, which may help me figure out what I need, is how does one manually work through a mail merge? I only see the wizard, but what if I've already created a document and just want to change a few fields? I don't want to have to enter a wizard and work through the entire thing

[libreoffice-users] Mail Merge from different tables in database?

2013-11-18 Thread minhsien0330
Dear all: Can I create a mail merge that include data from different tables in database? Suppose that I have a ods file with 2 sheets (sheet1 and sheet2), I setup a connection to this spreadsheet in Base for using Mail Merge. Then I creat a odt file that linked some data in database from Table1

Re: [libreoffice-users] Mail merge formatting

2011-07-07 Thread Steve Edmonds
On 8/07/11 7:35 AM, Cor Nouws wrote: Hi Steve, Steve Edmonds wrote (07-07-11 21:28) I am trying to perform a mail merge with numbers but can't seem to control the number format. I am merging with a .ods sheet with data. I have formatted the numbers in the sheet but in writer the formatting

[libreoffice-users] Does Libre Office have merge codes?

2011-09-16 Thread AMCooper63
I am VP of a rocketry club. I'm trying to convert my WordPerfect files to Libre Office. I've automated a lot of functions with WordPerfect's merge codes. I am trying to find similar functionality in Lebre Office. For those who don't know what WordPerfect merge codes are I'll attempt to explain

[libreoffice-users] Re: Does Libre Office have merge codes?

2011-09-18 Thread AMCooper63
Merge fields are only the beginning. I found those. What I need is the ability to use code to do things with the data in the mail merge. I found conditional fields. But that isn't enough yet. I need to be able to do things like I described in the first post. Also, based upon the value of a field

Re: [libreoffice-users] Re: Calc - Merge multiple discontiguous selections at the same time?

2011-10-11 Thread jorge
Hi: I didn't the question but it interest me. I tried to use macro but I can't use because: a) If I selected all the cells that I want to merge ... nothing pass. b) If I select the first and run the macro ... appears a mesage that merge isn't found method

[libreoffice-users] Three-way-merge: How to do that?

2012-01-30 Thread Johannes Sixt
I want to do a three-way merge of three versions of a Writer document. I have: - Base.odt - the original version - Theirs.odt - a version of Base.odt modified by someone else - Ours.odt - a version of Base.odt that I modified. Now I want to integrate the modifications that change Base.odt

Re: [libreoffice-users] More mail merge help needed

2013-08-22 Thread Steve Edmonds
a .doc template and I don't know if the LO form for a merge translates to a .doc. Someone else may know. I pretty much follow the steps that have been described in this list, so possibly trying to merge with a spread sheet may be a first step before trying to create a template for SF. Create your

Re: [libreoffice-users] Problems with Merge in Draw

2013-01-21 Thread Daniel A. Rodriguez
2013/1/21 Kai Bettzieche kai.bettzie...@gmx.net Dear all, I'm experiencing a problem with Draw's function merge: As you can see in attachment #1 (map_1.png), I'm trying to build a map (yeah, not exactly, what Draw is there for ..) Now I'd like to merge the roads (the long grey boxes

Re: [libreoffice-users] Re: Calc - Merge multiple discontiguous selections at the same time?

2011-10-12 Thread jorge
...the result was: Merge A1 with A2 but lost ge Merge B3 with B4 but lost guez Merge D2 with D3 but lost seca I thought that merge multiple range macro would bring this: Merge the content of A1:A2 with B3:B4 and with D2:D3 in other cell, like this: D6 = jorgerodriguezfonseca I

[libreoffice-users] Fwd: Regarding Mail Merge sending Document

2013-08-24 Thread Shiv Chauhan
Dear Sir, I have created a document using mail merge and inserted data of 10 users by data source.. Name:- Mail ID:- Adderss:- Age:- but when i sent this document to all employees on their mail id which is used in document. full document sent on every id and every employee can read information

[libreoffice-users] Mail merge formatting

2011-07-07 Thread Steve Edmonds
Hi. I am trying to perform a mail merge with numbers but can't seem to control the number format. I am merging with a .ods sheet with data. I have formatted the numbers in the sheet but in writer the formatting changes. 3.0012 prints as 3, 0.497 prints as 0.50 and 423.56 prints as 423.56

Re: [libreoffice-users] Does Libre Office have merge codes?

2011-09-17 Thread Cor Nouws
AMCooper63 wrote (17-09-11 05:07) I am VP of a rocketry club. I'm trying to convert my WordPerfect files to Libre Office. I've automated a lot of functions with WordPerfect's merge codes. [...] Is there similar functionality in Libre Office? Yes there is: Mail merge fields. I guess

[libreoffice-users] Mail merge seems slow

2011-10-30 Thread Steve Edmonds
Hi. I am performing mail merges (actually data into a certificate to print) and find the merge is slow. I have 3.3.4 on Suse 11.0. When I merge a simple document with 109 records in a calc sheet (4 items of data per record) Print Monitor takes 6.5 minutes before I can start printing

[libreoffice-users] Re: Mail Merge print from Query instead of table.

2012-01-27 Thread Tom
Hi :) I thought it was better practice to use Queries than Tables to build report/forms/mail-merge from and then print the result? I don't know if anyone has an answer to all this? Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Mail-Merge-print-from

[libreoffice-users] Re: Multi-source Mail Merge

2015-05-10 Thread Andreas Säger
Merge all sheets into one and do what you want with it: https://forum.openoffice.org/en/forum/viewtopic.php?f=21p=351686 -- View this message in context: http://nabble.documentfoundation.org/Multi-source-Mail-Merge-tp4148287p4148330.html Sent from the Users mailing list archive at Nabble.com

Re: [libreoffice-users] Making two rows of a table into a Header

2015-09-01 Thread Gordon Burgess-Parker
On 01/09/15 11:52, Brian Barker wrote: o Merge all the tables into a single table. (Use Table | Merge Tables or right-click | Merge Tables.) Better still, create them that way in the first place. It was a downloaded document and was already one table o Go to Table | Table Properties

[libreoffice-users] accounts to merge

2016-12-31 Thread paolobenve
In past times I had a bugs.documentfoundation.org account, then I created another. Is it possible that an administrator merge the two accounts, or, alternatively, change bug reporter so that all bugs I reported show the same reporter? -- View this message in context: http

[libreoffice-users] From field in mail merge emails

2022-02-14 Thread Brian Scott
Hi all, So I've finally got mail merge emails working but have one last (hopefully) problem. I can't seem to change the name the recipient sees when they receive the email. I go into Tools/Options/LibreOffice Writer/Mail Merge Email. I change Your Name and hit okay (tried apply as well

Re: [libreoffice-users] More mail merge help needed

2013-08-22 Thread Carl Paulsen
Yes, that's the way I was working at this. But I realize there may be other approaches. Still, it made me wonder about hand-generating mail merge documents even without Salesforce, which is also something I'd like to understand how to do. I occasionally get questions about spreadsheets

[libreoffice-users] mail merge does not send appropriate documents (was: Fwd: Regarding Mail Merge sending Document)

2013-08-25 Thread Nino Novak
Hi Shiv, I can confirm the bug with LibreOffice 4.1.0.4 and 3.6.5.2. Did you search bugzilla (http://bugs.freedesktop.org) if it has been reported already? Regards, Nino Am 24.08.2013 07:15, schrieb Shiv Chauhan: Dear Sir, I have created a document using mail merge and inserted data of 10

[libreoffice-users] mail merge does not send appropriate documents (was: Fwd: Regarding Mail Merge sending Document)

2013-08-25 Thread Nino
Hi Shiv, I can confirm the bug with LibreOffice 4.1.0.4 and 3.6.5.2. Did you search bugzilla (http://bugs.freedesktop.org) if it has been reported already? Regards, Nino Am 24.08.2013 07:15, schrieb Shiv Chauhan: Dear Sir, I have created a document using mail merge and inserted data of 10

Re: [libreoffice-users] Problems with Merge in Draw

2013-01-21 Thread Regina Henschel
Hi Kai, Kai Bettzieche schrieb: Dear all, I'm experiencing a problem with Draw's function merge: As you can see in attachment #1 (map_1.png), I'm trying to build a map (yeah, not exactly, what Draw is there for ..) Now I'd like to merge the roads (the long grey boxes) with the corners

[libreoffice-users] Mail Merge on Linux: Save files with a field as part of the name

2013-09-07 Thread L Duperval
Hi, On Linux, I would like to do a mail merge and save the documents using one of the fields as part of the name. From this link: http://ask.libreoffice.org/en/question/13555/mail-merge-to-separate- documents-with-file-names-based-on-merge-fields/ It seems like I should have an option to use

Re: [libreoffice-users] Mail Merge and Labels

2013-12-04 Thread Brian Barker
At 10:41 04/12/2013 -0500, Jeff Hahn wrote: ... it would be nice to be able to do a mail merge directly from the spreadsheet without creating a database file. I don't know why you think this is not possible. The Mail Merge chapter of the manual says: LibreOffice can access a wide variety

Re: [libreoffice-users] Mail merge formatting

2011-07-07 Thread Cor Nouws
Hi Steve, Steve Edmonds wrote (07-07-11 21:28) I am trying to perform a mail merge with numbers but can't seem to control the number format. I am merging with a .ods sheet with data. I have formatted the numbers in the sheet but in writer the formatting changes. 3.0012 prints as 3, 0.497 prints

[libreoffice-users] Mail Merge print from Query instead of table.

2012-01-26 Thread oldlace
LibreOffice 3.3.4 on Mint 11 If I print a mail merge form that is created from a* table*, then in the print dialogue the correct table is selected. This is what I expect to happen. However a mail merge form that is created from a valid *query* (that is based on multiple tables) requires me

Re: [libreoffice-users] Calc - Merge cells

2011-01-28 Thread Luuk
of this list? My problem: In Calc, I frequently merge and unmerge (split) cells. In OO.org I was able to assign a key combo to one of the two 'Format - Merge' entries. (Don't know why there were two, but there were two going back several versions.) The one I really, really, really liked, and assigned

[libreoffice-users] Multi-source Mail Merge

2015-05-09 Thread A
with one person. Each person can have multiple baskets (although that's probably not relevant). I also have a letter, with which I want to do a mail merge - against each spreadsheet. i.e. each letter needs to draw multiple pieces of data (eggs) from each spreadsheet, one letter per spreadsheet

Re: [libreoffice-users] Mail Merge Label Problem

2023-04-12 Thread Robert Großkopf
Hi Matt, We are trying to generate labels from the Mail Merge component of Libreoffice 7.2. We can work through the mail merge system however for some reason the Mail Merge can't locate a Database to pull the contact information from. Did you register any database file? You will nee a Base

[libreoffice-users] Re: Need Help AGAIN with Mail Merge

2012-06-24 Thread thomasjk
Turn off View---Field names. It sounds like you have this toggled on. - Tom K. -- View this message in context: http://nabble.documentfoundation.org/Need-Help-AGAIN-with-Mail-Merge-tp3992012p3992015.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

[libreoffice-users] Re: Using photos within a Mail Merge setup??

2012-10-06 Thread robertjm
Sorry for the badly formatted text. Will report below with proper formatting. -- View this message in context: http://nabble.documentfoundation.org/Using-photos-within-a-Mail-Merge-setup-tp4011420p4011636.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

Re: [libreoffice-users] Mail merge

2011-06-27 Thread amine amine
Salam, Mail Merge is essential, crucial and very important that i never! -- Amine Arrahmane Achargui Effectiveness (“Do the right things”) Efficiency (“Do the things right”) Great to see that great projects choose to use great projects to become even greater -- Unsubscribe instructions: E

Re: [libreoffice-users] Mail merge formatting

2011-07-07 Thread lee
Steve Edmonds steve.edmo...@ptglobal.com writes: Hi. I am trying to perform a mail merge with numbers but can't seem to control the number format. The mailmerge tool is too buggy to be used. -- html messages are obsolete -- Unsubscribe instructions: E-mail to users+h

[libreoffice-users] mail merge duplicates entries

2012-03-26 Thread Ron Gregor
Andreas, Thanks for the suggestion. Can you tell me how to use a query when printing with a mail merge? I didn't see any place to enter a query. Ron -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing

[libreoffice-users] Writer Merge File

2011-02-25 Thread Mark Stanton
After some experimenting it seems to me that if I set up a Writer document to link to a csv file as its datasource it stays with exactly that file. If I try to include new data by making a new version of the merge file (ie, exactly the same name), I don't get the new data, only the old data

[libreoffice-users] Fwd: Mail Merge Tutorial

2011-03-30 Thread Dave Barton
Original Message Subject: Mail Merge From: Tom Barrett t...@tombarrett.id.au Hi I just noticed a tutorial on the complicated topic of mail merging with OpenOffice. Just thought you may like to mention an online tool I've just launched that makes mail merging really

[libreoffice-users] Problems with Merge in Draw

2013-01-21 Thread Kai Bettzieche
Dear all, I'm experiencing a problem with Draw's function merge: As you can see in attachment #1 (map_1.png), I'm trying to build a map (yeah, not exactly, what Draw is there for ..) Now I'd like to merge the roads (the long grey boxes) with the corners (the grey circles). Result: see

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

2014-03-19 Thread Steve Edmonds
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

Re: [libreoffice-users] Calc - Merge cells

2011-01-28 Thread T. R. Valentine
I use Ctrl-G to 'group' (merge) cells. It works to merge cells, but not to unmerge (split) them as it did in OO.o On 28 January 2011 03:51, Luuk luu...@gmail.com wrote: Are you sure you did not assign a macro to this key? If not, can you write what keys you used in OO to do this? On 28-01

Re: [libreoffice-users] Help with Mail Merge

2017-08-30 Thread Remy Gauthier
Hello, Sorry for the long response time, I only really saw your message today. When I do mail merges, I use the "Data Sources" available from the View menu (Ctrl+Shift+F4) to select my data source and filter what I want to use for the merge, and then to activate the mailing wizard (

Re: [libreoffice-users] Multi-source Mail Merge

2015-05-11 Thread A
data). I have multiple baskets each with multiple eggs. Each basket (spreadsheet) is associated with one person. Each person can have multiple baskets (although that's probably not relevant). I also have a letter, with which I want to do a mail merge - against each spreadsheet. i.e. each letter

Re: [libreoffice-users] Multi-source Mail Merge

2015-05-11 Thread T. R. Valentine
to do a mail merge - against each spreadsheet. i.e. each letter needs to draw multiple pieces of data (eggs) from each spreadsheet, one letter per spreadsheet. Normally to do a mail merge you have one data source. The problem of course is that I don't have one data source, I have

Re: [libreoffice-users] Mail merge manual field entry

2013-08-17 Thread Tom Davies
August 2013, 23:22 Subject: Re: [libreoffice-users] Mail merge manual field entry A related question, which may help me figure out what I need, is how does one manually work through a mail merge?  I only see the wizard, but what if I've already created a document and just want to change a few

Re: [libreoffice-users] Mail merge manual field entry

2013-08-22 Thread Carl Paulsen
and regards from Tom :) From: Carl Paulsen carlpaul...@comcast.net To: users@global.libreoffice.org users@global.libreoffice.org Sent: Monday, 12 August 2013, 23:22 Subject: Re: [libreoffice-users] Mail merge manual field entry A related question, which may help

[libreoffice-users] Re: Problems with Merge in Draw

2013-01-21 Thread Kai
Hi Tom thanks for the hint :) Here you will find the attachments: map_1.png http://nabble.documentfoundation.org/file/n4030970/map_1.png map_2.png http://nabble.documentfoundation.org/file/n4030970/map_2.png map_1 shows the map before merging, map_2 shows the map after trying to merge

[libreoffice-users] Problems with mail merge

2014-03-16 Thread A
, opened in Writer. I then entered various Fields from this CSV file (now converted to a base file by the mail merge wizard) into my Writer document for purposes of mail merge. The end result mail merge post processed document has the field names, no values. The original document with the fields

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

2014-03-20 Thread Mark Bourne
can see that might not be so easy as an instruction if there are non-technical users of your merge document. Whatever works for you and your users is best ;o) Mark. Steve Edmonds wrote: And thanks to the discussion I think I have a much better understanding and can iron out the problems our

[libreoffice-users] Mail merge doesn't send e-mails

2011-11-20 Thread annedonnelly
Using LibreOffice 3.4.4 OOO340m1 (Build:402) on Windows 7 Home Premium SP1 I use Writer to mail merge from a .CSV file and send the results via e-mail (I have been doing this successfully using OO Writer on Windows XP for a number of years). The input file has only 5 records. The records

[libreoffice-users] Crashes with e-mail merge

2012-01-04 Thread Ferry Toth
Problem description: When running mail merge with a document header that contains an image, libre office crashes without sending the mail. Steps to reproduce: Tools Mail merge Wizard Fill in all the data to get simplest type of email merge (i.e. Hello field somemessage, Bye) without any

[libreoffice-users] Re: Crashes with e-mail merge

2012-01-05 Thread Ferry Toth
of type gnome I can do the emailmerge and then quickly change back to KDE on the first session. Ferry Ferry Toth schreef op wo 04-01-2012 om 23:02 [+0100]: Problem description: When running mail merge with a document header that contains an image, libre office crashes without sending

Re: [libreoffice-users] mail merge

2011-06-18 Thread planas
Pamela, On Sat, 2011-06-18 at 12:23 -0400, parks wrote: I have 3.3 version on windows7 home premium 64 bit. I used word and excel to produce invoices. I could specify what groups to merge and print based on a specific field and then if the date in the cells were blank or nonblank. I

Re: [libreoffice-users] Multi-source Mail Merge

2015-05-11 Thread T. R. Valentine
with multiple eggs. Each basket (spreadsheet) is associated with one person. Each person can have multiple baskets (although that's probably not relevant). I also have a letter, with which I want to do a mail merge - against each spreadsheet. i.e. each letter needs to draw multiple pieces of data (eggs

Re: [libreoffice-users] Mail Merge Label Problem

2023-04-11 Thread Michael H
, LibreOffice Base, and finally the merge writer file.) On Tue, Apr 11, 2023 at 4:56 PM Matt Brown <6bro...@gmail.com> wrote: > Good day, > > We are trying to generate labels from the Mail Merge component of > Libreoffice 7.2. We can work through the mail merge system however

Re: [libreoffice-users] calc: method to subdivide individual cells

2013-02-13 Thread Brian Barker
At 20:14 13/02/2013 -0500, Pete Bonly wrote: Does calc have some kind of method to subdivide individual cells? Yes - but you have to think of the problem the other way about. You can select a number of cells and then *merge* them, either by going to Format | Merge Cells or using the Merge

Re: [libreoffice-users] calc: method to subdivide individual cells

2013-02-14 Thread Tanstaafl
On 2013-02-14 1:23 AM, Brian Barker b.m.bar...@btinternet.com wrote: At 20:14 13/02/2013 -0500, Pete Bonly wrote: Does calc have some kind of method to subdivide individual cells? Yes - but you have to think of the problem the other way about. You can select a number of cells and then *merge

[libreoffice-users] Need Help AGAIN with Mail Merge

2012-06-24 Thread Charles218
This is a follow-up to my query from earlier today. I finally have everything working in mail merge except for the final step. I execute the print command and then answer yes to the do you want to print a form letter message. The data source shows up as it should, I can see the headers

[libreoffice-users] Re: Need Help AGAIN with Mail Merge

2012-06-25 Thread Charles218
Andreas, In going through the print procedure again, this time following your step by step directions, I believe that the problem is solved. There are two ways to get to the mail merge area, one is by using the Print command and responding yes to the do you want to print a form letter dialog

Re: [libreoffice-users] Re: [Writer] Data to Fields is not working

2012-10-04 Thread Mirosław Zalewski
Andreas, On 04/10/2012 at 23:08, Andreas Säger ville...@t-online.de wrote: 1. Open your letter template with fields. What fields do you refer to? How do I place them? I know I can place fields from database using Insert → Fields → Other → Database → Mail merge fields. But after placing

[libreoffice-users] Writer: remove/merge pages

2013-01-12 Thread IGraham
question* The document is split in to four pages, how do I remove/merge the pages They don't seem to be manually inserted as placing cursor in front of first character of next page and deleting doesn't remove the page *Secondary question * Does Libraoffice normally struggle with large documents

Re: [libreoffice-users] Mail Merge from different tables in database?

2013-11-18 Thread Stefan Weigel
Hi Minhsien0330 Am 18.11.2013 09:55, schrieb minhsien0330: Suppose that I have a ods file with 2 sheets (sheet1 and sheet2), I setup a connection to this spreadsheet in Base for using Mail Merge. [...] Do you know how to include data the come from different database Tables when using Mail

[libreoffice-users] Mail Merge and Labels

2013-12-04 Thread Jeff Hahn
I tried to do my labels for Christmas cards using LO's mail merge. I was able to create the data base and print without difficulty. Unfortunately, the entire third column was not properly spaced and printed outside of the label, a couple of spaces to the left. The first two columns were

Re: [libreoffice-users] Mail Merge and Labels

2013-12-04 Thread Paul D. Mirowsky
Where you merging to Writer? On 12/4/2013 10:41 AM, Jeff Hahn wrote: I tried to do my labels for Christmas cards using LO's mail merge. I was able to create the data base and print without difficulty. Unfortunately, the entire third column was not properly spaced and printed outside

[libreoffice-users] Re: Mail merge formatting

2011-07-11 Thread Twayne
In news:4e1608f7.1010...@ptglobal.com, Steve Edmonds steve.edmo...@ptglobal.com typed: Hi. I am trying to perform a mail merge with numbers but can't seem to control the number format. I am merging with a .ods sheet with data. I have formatted the numbers in the sheet but in writer

[libreoffice-users] Problem with Mail Merge

2011-08-31 Thread Mena Art Gallery
First, do I need to join a group in order to request help? Second, I am running the old OpenOffice 3.2.1 under Windows. I am attempting to use mail merge to put address information on a newsletter I am sending out. I have opened the file with the newsletter, selected Tools Mail Merge

Re: [libreoffice-users] merged cells in Writer (saved as Word 97/2000/xp/2003)

2011-09-14 Thread JOE Conner
On 9/14/2011 11:07 AM, James wrote: 1. Create a new Writer document 2. Create a new table (whatever it defaults to (but at least 2 rows)) 3. Type 'test' in the top left cell 4. Merge the 1st and 2nd cells in the first column 5. SaveAs (change the format to Microsoft Word 97/2000/xp/2003) 6

Re: [libreoffice-users] merged cells in Writer (saved as Word 97/2000/xp/2003)

2011-09-14 Thread James
On 09/14/11 14:58, JOE Conner wrote: On 9/14/2011 11:07 AM, James wrote: 1. Create a new Writer document 2. Create a new table (whatever it defaults to (but at least 2 rows)) 3. Type 'test' in the top left cell 4. Merge the 1st and 2nd cells in the first column 5. SaveAs (change the format

[libreoffice-users] email merge across sessions

2011-09-20 Thread Brian Katzung
After doing some research into both the interface and the documentation, I have not found any way to process an email merge to the point of customizing the individual email content, saving the customizations and then emailing the merge in a subsequent session of LibreOffice. Is there a way

[libreoffice-users] Problem with Mail Merge

2011-10-11 Thread Barbara Tobias
We have been using a combination of OpenOffice and Windows 7 for quite some time to send out a newsletter. A couple of months ago, with nothing changed that we could spot, the mail merge function stopped working. After opening Tools/Mail Merge Wizard, we can select starting document and select

[libreoffice-users] Re: Mail Merge Crashes

2011-12-11 Thread Tom
can reasonably get. So, having 2 versions makes sense. It might well be soem other problem with mail-merge tho. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Mail-Merge-Crashes-tp3577418p3578194.html Sent from the Users mailing list archive at Nabble.com

Re: [libreoffice-users] Mail Merge Crashes

2011-12-13 Thread Cor Nouws
Hi Paul, paul wrote (11-12-11 15:36) I'm running LibreOffice 3.4.4 on openSuse 11.3 (x86_64). I've created a docmument that I want to use for Mail Merging have a connected to the database. If I use the Mail Merge tool, in preview I can see all the correct entries. However when I try to save

Re: [libreoffice-users] Feature request for LibreOffice Calc

2011-12-17 Thread Don Myers
Hi, There is a button on the format toolbar to merge and unmerge cells. The button appears as grayed out until you select some cells. It has always worked great for me. Don On 12/16/2011 05:58 PM, Jochen Betz wrote: I had some problems to find a way to place my feature request. So my first

Re: [libreoffice-users] Re: Mail Merge print from Query instead of table.

2012-01-27 Thread Fernand Vanrie
Query's are not working , Views (who are a kind of query's) are by LO seen as tables and act like that in mailmerge Have provided a temporary work around for myself by creating temporary tables from my Query and using these for my mail merge. However it would be much less of a convoluted

[libreoffice-users] Re: More mailmerge woes

2012-03-17 Thread Andreas Säger
Am 17.03.2012 11:15, Mark Stanton wrote: The File / Print menu will ask if you want to print a mail merge. Just say yes then enjoy the olde OOo v1 wizard. So it does! That's cute. Unfortunately it only lists tables as data sources, and mine is a query :-( Mark Stanton One small step

[libreoffice-users] Re: mail merge duplicates entries

2012-03-26 Thread Andreas Säger
Am 26.03.2012 14:14, Ron Gregor wrote: Andreas, Thanks for the suggestion. Can you tell me how to use a query when printing with a mail merge? I didn't see any place to enter a query. Ron Hit F4, right-click the data source - Open Database... Add your query to the database, save

[libreoffice-users] Re: Writer Merge File

2011-02-26 Thread Alexander Thurgood
Le 25/02/11 15:19, Mark Stanton a écrit : Hi Mark, After some experimenting it seems to me that if I set up a Writer document to link to a csv file as its datasource it stays with exactly that file. If I try to include new data by making a new version of the merge file (ie, exactly

Re: [libreoffice-users] Re: Multi-source Mail Merge

2015-05-10 Thread A
. For example if I need data from A2, C3, `sheet2`D11, F32 and G12 in each file, merging the files would mean A2 is suddenly A42 or some such for what was file2. I don't see how to make this work. On 05/10/2015 11:33 AM, Andreas Säger wrote: Merge all sheets into one and do what you want

[libreoffice-users] Mail Merge from Calc spreadsheet.

2016-11-10 Thread lismurn
I have, for many years been writing letters to several hundred people detailing their donations to various charities. Access to Microsoft Office which I used is now very restricted so I was wondering is it possible to mail merge into a Writer document information such as name, address etc

[libreoffice-users] Best practices when working with LibreOffice Impress?

2018-05-11 Thread Gilles
/better to merge and convert LibreOffice files directly into HTML instead of going through PDF? If that's the case, what tool would you recommend (Windows or Linux)? 2. If going through PDF doesn't matter, what tool + settings do you recommend to a) convert the files into PDF (if LO isn't good enough

[libreoffice-users] mail merge woes

2019-12-04 Thread Oszkó Albert
# - eg 15) in a cell) and by dragging down the little rectangle in the lower right corner, all cells are filled correctly. BUT, when these data are substituted by mail merge into the form, only the number, in our case, 15 is displayed. So, how could the whole string be copied? (Mail merge in latter

[libreoffice-users] Update a mailmerge file

2021-08-15 Thread Michael H
Is there a way to dynamically set up a Calc->Base->Writer mail merge so that changes in Calc can be pushed through to Writer? I don't see how to do it. I've made a fairly complex mail merge file (some 25 fields). I added another 50ish items to the spreadsheet thinking I could refresh th

[libreoffice-users] Scalc I cannot merge cells, also I selected and unprotected them

2023-10-11 Thread Uwe Brauer
Hi I have a document with several sheets, I selected some cells on a row, made sure they are unprotected, and then selected the merge option, however that option remained in grey and could not been selected. What is the problem here? In a new scalc document I have no problem to merge cells

Re: [libreoffice-users] Serial Letters

2012-10-16 Thread Steve Edmonds
Hi. I wish mail merge and form letter would be distinguished. Are you merging to mail or a printed form (that may be a letter). I regularly mail merge (though it is a form merge and not to any mail application) from an ods sheet, can you dump the mysql data to merge to a sheet and then do your

Re: [libreoffice-users] Re: Problems with Merge in Draw

2013-01-22 Thread Regina Henschel
trying to merge the first couple of shapes. I did use the context menu. I did use primitive shapes with regular fillings. Here is the file to the problem: roads.odp http://nabble.documentfoundation.org/file/n4030970/roads.odp That's good. I use LO4.0 and there is no problem with merging. You

Re: [libreoffice-users] Mail Merge question

2021-05-29 Thread Suzie Reedy
Robert, Thank you so much! That is exactly what I was looking for! Just as an addendum for those who are brand new to Libre Office: If the More Fields Option doesn’t respond (mine didn’t at first and that’s why I couldn’t find Mail Merge Fields) choose Insert—Field—Command F2 Then once you

[libreoffice-users] Bug 63388: Mail Merge Email

2013-04-10 Thread Dan Lewis
I have filed this bug because I can not get LibreOffice to test the settings I enter into Tools Options LibreOffice Writer Main Merge. It freezes everytime. All the information I enter is copied from the Account Settings in Thunderbird. I have verified that the password I entered

Re: [libreoffice-users] Mail Merge and Labels

2013-12-04 Thread Dave Liesse
I agree that the merge can be done from Calc -- I do that frequently. I also agree, though, that it takes more effort than it should to set up labels. Even using the templates included in the program I've never had the output fit properly on the first pass (but I've learned to print

[libreoffice-users] Mail merge saved into individual documents

2011-07-12 Thread Olivier Bietzer
Hello, Using LibreOffice after some years under OOo... The Mail merge has an option to save the merged documents into one single document OR into individual documents, with some parameters to give an individual name to each doc... But this does NOT work, it does only create one single document

[libreoffice-users] Re: Selecting record range in mail merge.

2011-08-22 Thread Andreas Säger
Hi, Similar bug description here: http://openoffice.blogs.com/openoffice/2010/07/slight-bug-in-openoffice-mail-merge.html It works well when you manually select the records to be printed. -- View this message in context: http://nabble.documentfoundation.org/Selecting-record-range-in-mail-merge

  1   2   3   4   5   6   7   8   9   >