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

Re: [libreoffice-users] Mail Merge Label Problem

2023-04-11 Thread Michael H
Good news is that I made mailmerge work in 6.4, so it is possible. However, the ONLY way i see to make it work is to start with a calc spreadsheet not a database, and then register that Calc spreadsheet AS a database, and then do the mailmerge with all three programs open (Calc spreadsheet,

[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 email dialog box not opening

2022-02-12 Thread Steve Edmonds
Hi, I think you need mail merge for what you want to do. There is a step by step here for LO5 that may help https://www.maths.cam.ac.uk/computing/files/email/LibreOffice5mailmerge.pdf steve On 13/02/2022 07:44, Brian Carey wrote: Hi, I'm hoping someone can help with this frustrating

[libreoffice-users] mail merge email dialog box not opening

2022-02-12 Thread Brian Carey
Hi, I'm hoping someone can help with this frustrating problem. I have tried in both Linux (Arch) and Windows 11. I have set up the mail server connection and tested it. I have set up the email client. I have created a spreadsheet which includes email addresses, connected to it in writer and

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

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 database.

[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 woes

2019-12-04 Thread Oszkó Albert
Hi all, I try to copy data into a form from a  Calc spreadsheet. The data should be entered as fields, later replaced by data from the spreadsheet. One data is a custom formatted number e.g. "ZN-"#"/2019". It just works fine in Calc, I just write the number (# - eg 15) in a cell) and by

Re: [libreoffice-users] Mail Merge testing account fails

2018-05-16 Thread Alex Kempshall
Hi Max What version of LibreOffice are you using? Have you checked your settings are correct? When I change the settings I've found that the "Test Settings" can fail. Closing down LibreOffice completely and restarting always seems to fix it for me. Alex On 15/05/18 13:53, Maximilien

[libreoffice-users] Mail Merge testing account fails

2018-05-15 Thread Maximilien Chaumon
Dear all, I'm trying to set up sending emails with mail merge. I entered my credentials etc. in Tools>Options>LibreOffice Writer>Mail Merge E-mail, but when I hit "Test Settings", it hangs for a couple minutes and shows me the following error. Same error with email accounts from several

Re: [libreoffice-users] Mail merge template and tutorial

2017-10-19 Thread zahra a
hi. thanks so much for your work and God bless you! On 10/19/17, Dave Koelmeyer wrote: > Hi All, > > For any folks looking for easy guidance on creating mail merges with > LibreOffice, I've created a video tutorial to be used in combination > with a data

[libreoffice-users] Mail merge template and tutorial

2017-10-19 Thread Dave Koelmeyer
Hi All, For any folks looking for easy guidance on creating mail merges with LibreOffice, I've created a video tutorial to be used in combination with a data source template: https://www.apertura.co.nz/libreofficemailmerge Hope this helps—feedback of course is welcome. Cheers, Dave -- Dave

Re: [libreoffice-users] Mail merge wizard: how to remove an address list

2017-01-23 Thread Brian Barker
At 11:02 23/01/2017 +0100, Angelo Spognardi wrote: It seems like you cannot remove address lists once you've added them during the wizard process. Since many of them were trials (and errors...), I'm stuck with a list of erroneous and useless address lists. How can I remove them? The simple

[libreoffice-users] Mail merge wizard: how to remove an address list

2017-01-23 Thread Angelo Spognardi
It seems like you cannot remove address lists once you've added them during the wizard process. Since many of them were trials (and errors...), I'm stuck with a list of erroneous and useless address lists. How can I remove them? -- To unsubscribe e-mail to:

Re: [libreoffice-users] mail merge is incomplete

2016-12-30 Thread Albert , Oszkó
2016-12-28 14:20 keltezéssel, Cor Nouws írta: Hi Alberto, Albert, Oszkó wrote on 24-12-16 20:42: I have LO 5.2.3.3 on openSUSE Leap42.2 with KDE. Selecting mailmerge wizard in LO writer there are only 5 steps included. I cannot figure out what is missing to complete the wizard to 8 steps and

Re: [libreoffice-users] mail merge is incomplete

2016-12-28 Thread Cor Nouws
Hi Alberto, Albert, Oszkó wrote on 24-12-16 20:42: > I have LO 5.2.3.3 on openSUSE Leap42.2 with KDE. Selecting mailmerge > wizard in LO writer there are only 5 steps included. I cannot figure out > what is missing to complete the wizard to 8 steps and being able to send > the letters via email.

Re: [libreoffice-users] mail merge is incomplete

2016-12-28 Thread Alex Kempshall
On 24/12/16 19:42, Albert, Oszkó wrote: I have LO 5.2.3.3 on openSUSE Leap42.2 with KDE. Selecting mailmerge wizard in LO writer there are only 5 steps included. I cannot figure out what is missing to complete the wizard to 8 steps and being able to send the letters via email. This is the

Re: [libreoffice-users] mail merge is incomplete

2016-12-24 Thread Paolo Debortoli
Hi. I heard more times there are still problems with mail merge function (as noted even in monaco, germany), but it provides its already functions: http://blog.worldlabel.com/2012/mail-merge-address-labels-in-the-excellent-free-libreoffice.html On Saturday, December 24, 2016 8:42 PM,

[libreoffice-users] mail merge is incomplete

2016-12-24 Thread Albert , Oszkó
Hi all, I have LO 5.2.3.3 on openSUSE Leap42.2 with KDE. Selecting mailmerge wizard in LO writer there are only 5 steps included. I cannot figure out what is missing to complete the wizard to 8 steps and being able to send the letters via email. Any help is welcome. Best regards, Albert

Re: [libreoffice-users] Mail Merge from Calc spreadsheet.

2016-11-14 Thread Kevin O'Brien
Yes, it is possible and works much the same way. https://help.libreoffice.org/Writer/Mail_Merge Regards, On Thu, Nov 10, 2016 at 4:38 PM, lismurn wrote: > I have, for many years been writing letters to several hundred people > detailing their donations to various charities.

Re: [libreoffice-users] Mail Merge from Calc spreadsheet.

2016-11-10 Thread Remy Gauthier
Greetings, Yes, this is possible. When you call for the mail-merge assistant, you will be prompted to select a source. This source can be a CALC workbook or a BASE database. I have been preparing a letter of sorts for a small group for a couple of years and I have used both, though I now prefer

[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 and

Re: [libreoffice-users] Mail Merge - Labels

2015-10-29 Thread Mark Phillips
In my version of LibreOffice (4.2.8.2) there is a check box that says "Suppress lines with just empty fields" in the mail merge wizard. It is under the text box where you put the address information (ie ). Mark On Wed, Oct 28, 2015 at 1:33 PM, Stan Grigiski wrote:

Re: [libreoffice-users] Mail Merge - Labels

2015-10-29 Thread libreoffice-ml . mbourne
Stan Grigiski wrote: Hello, I noticed that when I try to mail merge a data base for labels, the program will not supress a field if there is no entry; it will create a space on the lable. For example, if I have the field "address 1" set for street number and street name and the field "address

[libreoffice-users] Mail Merge - Labels

2015-10-28 Thread Stan Grigiski
Hello, I noticed that when I try to mail merge a data base for labels, the program will not supress a field if there is no entry; it will create a space on the lable. For example, if I have the field "address 1" set for street number and street name and the field "address 2" set for apt#, if a

Re: [libreoffice-users] MAIL MERGE: Default fields Topic and Subject are only printed in first document

2014-07-27 Thread Alex McMurchy
*Bug 81782[1]* - MAILMERGE: Some fields (Title, Subject, Author) only printed to the first document I see that someone else has now confirmed that the bug has been present for a long time. Alex On Saturday 26 Jul 2014 16:06:26 Sven Schüring wrote: Hi Alex, thanks for your confirmation.

Re: [libreoffice-users] MAIL MERGE: Default fields Topic and Subject are only printed in first document

2014-07-27 Thread Sven Schüring
oh well, I'm looking forward that this problem would be fixed soon in one of the next LO versions. regards Sven On Sun, Jul 27, 2014 at 9:21 AM, Alex McMurchy mcmurchy1917-libreoff...@yahoo.co.uk wrote: *Bug 81782[1]* - MAILMERGE: Some fields (Title, Subject, Author) only printed to the

Re: [libreoffice-users] MAIL MERGE: Default fields Topic and Subject are only printed in first document

2014-07-27 Thread Alex Kempshall
Sven As a work-around have you considered hard-coding the Title and Subject in the Starting Document instead of inserting the Title and Subject fields? Alex On Sunday 27 Jul 2014 10:53:37 Sven Schüring wrote: oh well, I'm looking forward that this problem would be fixed soon in one of the

Re: [libreoffice-users] MAIL MERGE: Default fields Topic and Subject are only printed in first document

2014-07-26 Thread Alex McMurchy
Sven I can confirm your problem. I see Title/Subject only on the first page irrespective of whether I save the final merged document as a whole or as individual documents. I tested using the Mail Wizard tool. Raise it as a bug and post back here the reference. Alex On Thursday 24 Jul

Re: [libreoffice-users] MAIL MERGE: Default fields Topic and Subject are only printed in first document

2014-07-26 Thread Sven Schüring
Hi Alex, thanks for your confirmation. I've raised a bug to writer component as followed: https://www.libreoffice.org/get-help/bug/ regards, Sven On Sat, Jul 26, 2014 at 10:05 AM, Alex McMurchy mcmurchy1917-libreoff...@yahoo.co.uk wrote: Sven I can confirm your problem. I see

Re: [libreoffice-users] MAIL MERGE: Default fields Topic and Subject are only printed in first document

2014-07-26 Thread Mark Bourne
Number of the bug Sven raised is 81782: https://bugs.freedesktop.org/show_bug.cgi?id=81782 Mark. Sven Schüring wrote: Hi Alex, thanks for your confirmation. I've raised a bug to writer component as followed: https://www.libreoffice.org/get-help/bug/ regards, Sven On Sat, Jul 26, 2014

[libreoffice-users] MAIL MERGE: Default fields Topic and Subject are only printed in first document

2014-07-24 Thread Sven Schüring
Hi, I've some trouble with the default fields Topic and Subject of the document properties. They are only printed in the first mail merge document if I set the field to the document. At the following documents there are only whitespace. Can anyone confirm my problem? Is it a bug or a misused by

Re: [libreoffice-users] Mail Merge - Standard Filter issues

2014-06-03 Thread Sophie
Hi Vitorio, Le 02/06/2014 17:59, Vitorio Delage a écrit : Hello everybody! First of all, I would like to thank very warmly everyone involved with this great project. LibreOffice is amazing. Thanks a lot and it's nice to see the Académie using LibreOffice :) We are trying to setup a mail

Re: [libreoffice-users] Mail Merge - Standard Filter issues

2014-06-03 Thread Cor Nouws
Hi Vitorio, Here one of the mails in the thread, so that you can step in ;) Regards, Cor Sophie wrote (03-06-14 09:15) Hi Vitorio, Le 02/06/2014 17:59, Vitorio Delage a écrit : Hello everybody! First of all, I would like to thank very warmly everyone involved with this great project.

[libreoffice-users] Mail Merge - Standard Filter issues

2014-06-03 Thread Vitorio Delage
Hello everybody! First of all, I would like to thank very warmly everyone involved with this great project. LibreOffice is amazing. We are trying to setup a mail merge in my institution, based on LibreOffice, of course. And I would like to suggest 2 improvements: 1) Put more filter criterias

[libreoffice-users] Mail Merge - Standard Filter issues

2014-06-02 Thread Vitorio Delage
Hello everybody! First of all, I would like to thank very warmly everyone involved with this great project. LibreOffice is amazing. We are trying to setup a mail merge in my institution, based on LibreOffice, of course. And I would like to suggest 2 improvements: 1) Put more filter criterias

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

2014-03-20 Thread Mark Bourne
Alternatively, to save copying data into a common .ods file, you can keep one .odb file (e.g. mergesource.odb) but change which .ods file it points to. Open mergesource.odb, then Edit Database Properties, and change the path to spreadsheet document. Saves a bit of copying data around, but I

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

2014-03-19 Thread Jeff Prater
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

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] Mail merge with custom fields in LibreOffice 4.2

2014-03-19 Thread Jeff Prater
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

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

2014-03-19 Thread Don C. Myers
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

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

2014-03-19 Thread Jeff Prater
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

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

2014-03-19 Thread Alex McMurchy
Not sure if I've missed the point here - Create a spreadsheet .ods file with 3 columns each column headed - col1, col2, col3 Add two rows populating respective columns my first row contained 1, 2, 3 and the 2nd row a, b ,c so I had a spreadsheet .ods file that looked like this - col1col2

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

2014-03-19 Thread Jeff Prater
Yes--that does work. However, I already have a bunch of .odt documents mapped with the fields from the .ods spreadsheets. I don't want to have to delete all of the existing fields and reinsert them. I was hoping this would just work. Also, is there any way to not have LO cache (if that's the

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

2014-03-19 Thread Jeff Prater
Okay--I think I found the problem. When I opened one of my .odt documents and hovered over one of the fields, LO didn't seem to recognize it as a field. After going back to Insert Fields Other and manually reinserting the fields, the mail merge works correctly. I was hoping I wouldn't have to

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

2014-03-19 Thread A
I have not been following the discussion so I can't comment on anything that's gone before, but one thing I recently learned is that you can keep the fields window open while inserting all your fields. There are arrow buttons/icons that In some cases you can simply click those and it will

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

2014-03-19 Thread Steve Edmonds
And thanks to the discussion I think I have a much better understanding and can iron out the problems our users are having with the merge. We keep getting new lists to merge, all the same format. The secret to simplification is, once set up, to have an ods named mergesource.ods or something and

Re: [libreoffice-users] Mail Merge Wizard fails in 4.2.0

2014-02-18 Thread Tom Davies
Hi :) Sorry for the lack of responses! If it worked fine in 4.1.4 and stopped working in 4.2.0 then it's worth reporting as a bug-report. https://wiki.documentfoundation.org/BugReport Obviously it would be good to try 4.2.1 jic it has been fixed already but bug-squad/QA can quickly close the

Re: [libreoffice-users] Mail Merge Wizard fails in 4.2.0

2014-02-18 Thread Alex McMurchy
Hi Thanks Tom. I've raised bug - 75166 MAILMERGE: wizard produces empty address block Alex On Tuesday 18 Feb 2014 09:59:36 Tom Davies wrote: Hi :) Sorry for the lack of responses! If it worked fine in 4.1.4 and stopped working in 4.2.0 then it's worth reporting as a bug-report.

Re: [libreoffice-users] Mail Merge and Labels

2013-12-19 Thread Cliff Scott
** Reply to message from Brian Barker b.m.bar...@btinternet.com on Wed, 18 Dec 2013 17:10:24 + At 07:46 18/12/2013 -0600, Cliff Scott wrote: Initially I just want a sheet with all the labels the same. [...] For now I can obviously copy/paste to each label, but the wizard's way of

Re: [libreoffice-users] Mail Merge and Labels

2013-12-18 Thread Cliff Scott
that before. LO uses a frame based label template. I agree that a table based template makes far more sense. Virgil -Original Message- From: Don C. Myers Sent: Monday, December 16, 2013 7:34 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge

Re: [libreoffice-users] Mail Merge and Labels

2013-12-18 Thread Brian Barker
At 07:46 18/12/2013 -0600, Cliff Scott wrote: Initially I just want a sheet with all the labels the same. [...] For now I can obviously copy/paste to each label, but the wizard's way of entering data for one then propagating it to all is handy for like a set of return address labels. If you

Re: [libreoffice-users] Mail Merge and Labels

2013-12-18 Thread Don C. Myers
- From: Don C. Myers Sent: Monday, December 16, 2013 7:34 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels About 5 or 6 years ago when using OpenOffice to print Christmas labels, I ran across an article about using table style labels in OpenOffice instead

Re: [libreoffice-users] Mail Merge and Labels

2013-12-18 Thread Brian Barker
At 18:09 18/12/2013 -0500, Don C. Myers wrote: When you use the table style templates, the wizard does not work. It is designed for the frame style. What I do is fill in one label. Then if you have a 30 label sheet with 3 columns and 10 rows, I copy and paste it to the nest two labels to the

Re: [libreoffice-users] Mail Merge and Labels

2013-12-18 Thread Don Myers
Hi Brian, That is a much better solution. Thanks for suggesting it. Don On 12/18/2013 10:00 PM, Brian Barker wrote: At 18:09 18/12/2013 -0500, Don C. Myers wrote: When you use the table style templates, the wizard does not work. It is designed for the frame style. What I do is fill in one

Re: [libreoffice-users] Mail Merge and Labels

2013-12-17 Thread Cliff Scott
template makes far more sense. Virgil -Original Message- From: Don C. Myers Sent: Monday, December 16, 2013 7:34 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels About 5 or 6 years ago when using OpenOffice to print Christmas

Re: [libreoffice-users] Mail Merge and Labels

2013-12-17 Thread Peter Hillier-Brook
On 17/12/13 01:48, Don C. Myers wrote: Hi Virgil, They have really worked well for me. With the frame based templates, I always had trouble with the spacing on the labels changing as you would get into the bottom third of the label sheet. The frame based templates print out perfectly from top

Re: [libreoffice-users] Mail Merge and Labels

2013-12-17 Thread Don C. Myers
@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels About 5 or 6 years ago when using OpenOffice to print Christmas labels, I ran across an article about using table style labels in OpenOffice instead of the type which come with Word, OpenOffice, and LibreOffice. It is far easier

Re: [libreoffice-users] Mail Merge and Labels

2013-12-16 Thread Niklas Johansson
@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels Date: Thu, 5 Dec 2013 12:31:46 -0500 I just noticed this thread, and I have to chime in that, the last time I tried to create labels, I too noticed that the LO Avery 5160 template alignment was off. I had to adjust

Re: [libreoffice-users] Mail Merge and Labels

2013-12-16 Thread John Clegg
(right) column that is off. Jeff Hahn From: cuyfa...@hotmail.com To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels Date: Thu, 5 Dec 2013 12:31:46 -0500 I just noticed this thread, and I have to chime in that, the last time I tried to create labels

Re: [libreoffice-users] Mail Merge and Labels

2013-12-16 Thread Don C. Myers
the first 2 columns print properly (although the print starts right at the edge of the label). It is only the third (right) column that is off. Jeff Hahn From: cuyfa...@hotmail.com To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels Date: Thu, 5 Dec 2013 12:31:46

Re: [libreoffice-users] Mail Merge and Labels

2013-12-16 Thread Virgil Arrington
@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels About 5 or 6 years ago when using OpenOffice to print Christmas labels, I ran across an article about using table style labels in OpenOffice instead of the type which come with Word, OpenOffice, and LibreOffice. It is far easier to adjust

Re: [libreoffice-users] Mail Merge and Labels

2013-12-16 Thread Don C. Myers
: [libreoffice-users] Mail Merge and Labels About 5 or 6 years ago when using OpenOffice to print Christmas labels, I ran across an article about using table style labels in OpenOffice instead of the type which come with Word, OpenOffice, and LibreOffice. It is far easier to adjust the table style labels

Re: [libreoffice-users] Mail Merge and Labels

2013-12-05 Thread Virgil Arrington
, 2013 12:31 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels I just noticed this thread, and I have to chime in that, the last time I tried to create labels, I too noticed that the LO Avery 5160 template alignment was off. I had to adjust the contents

RE: [libreoffice-users] Mail Merge and Labels

2013-12-05 Thread Jeff Hahn
: [libreoffice-users] Mail Merge and Labels Date: Thu, 5 Dec 2013 12:31:46 -0500 I just noticed this thread, and I have to chime in that, the last time I tried to create labels, I too noticed that the LO Avery 5160 template alignment was off. I had to adjust the contents of every cell

[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 of the

RE: [libreoffice-users] Mail Merge and Labels

2013-12-04 Thread Jeff Hahn
Converted Calc to Database and then used Writer with the database file. Jeff Date: Wed, 4 Dec 2013 12:56:57 -0500 From: p_mirow...@bentaxna.com To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels Where you merging to Writer? On 12/4/2013 10:41 AM

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 of

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 on a

Re: [libreoffice-users] Mail Merge Salutation

2013-12-02 Thread Brian Barker
At 11:39 30/11/2013 -0800, Andrew Brager wrote: I'm trying to do a mail merge using the wizard (is there any other way?), and I'm having great difficulty making it do what I need to do. My data has one field for the name. A sample name is Gary L Judy A Smith. I simply want it to say Dear

[libreoffice-users] Mail Merge Salutation

2013-11-30 Thread Andrew
I'm trying to do a mail merge using the wizard (is there any other way?), and I'm having great difficulty making it do what I need to do. My data has one field for the name. A sample name is Gary L Judy A Smith. I simply want it to say Dear Gary L Judy A Smith, or even better Dear Gary

[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

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 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 a

[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] 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

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

[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 with

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 duplicates entries

2012-03-27 Thread Ron Gregor
Andreas, The query fix did work. While testing files to upload for the bug report it seems the work around is even easier. Once in mailmerge select any other table (query or even samples that ship with libreoffice) then select you table. Also if you don't care about the order if you

[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?

[libreoffice-users] mail merge duplicates entries

2012-03-23 Thread Ron Gregor
I have a odt file that I use mail merge to print to a pdf file. When I went to print the list I should have gotten 371 pages but I got 401 pages. I am using a odb file as a source which links to a very simple text file with one field. The text file has 371 entries and the odb shows 371

Re: [libreoffice-users] mail merge duplicates entries

2012-03-23 Thread Tom Davies
-users] mail merge duplicates entries To: users@global.libreoffice.org Date: Friday, 23 March, 2012, 17:24 I have a odt file that I use mail merge to print to a pdf file. When I went to print the list I should have gotten 371 pages but I got 401 pages. I am using a odb file as a source which links

Re: [libreoffice-users] mail merge duplicates entries

2012-03-23 Thread Tom Davies
Hi :) It just sounds like a bug to me tbh but i would still encourage a 'quick virus scan' just in case.  Regards from Tom :) --- On Fri, 23/3/12, Ron Gregor rgre...@wcnjcd.com wrote: From: Ron Gregor rgre...@wcnjcd.com Subject: [libreoffice-users] mail merge duplicates entries To: users

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

2012-01-27 Thread Mark Stanton
I thought it was better practice to use Queries than Tables to build report/forms/mail-merge from and then print the result? That's his whole point. Mailmerge doesn't appear to be able to use queries. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to:

[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 to

Re: [libreoffice-users] Mail Merge Crashes

2011-12-15 Thread Paul Rolfe
Hi Cor, I should have thought of that ! I created a new document and the Mail Merge worked using the existing database, so I gradually copied over the old document contents to the new document to see what happened. The crash happened when I added a header, and added an image into the

Re: [libreoffice-users] Mail Merge Crashes

2011-12-15 Thread Cor Nouws
Hi Paul, Paul Rolfe wrote (15-12-11 21:29) The crash happened when I added a header, and added an image into the header (a blank header worked fine). Thanks for finding this out! I'll post a bug report, as I've narrowed it down. Yes please do. I just checked BugZilla for such a bug and

Re: [libreoffice-users] Mail Merge Crashes

2011-12-15 Thread Paul Rolfe
Hi Cor, It's Bug 43876, Regards Paul On 15/12/11 20:48, Cor Nouws wrote: Hi Paul, Paul Rolfe wrote (15-12-11 21:29) The crash happened when I added a header, and added an image into the header (a blank header worked fine). Thanks for finding this out! I'll post a bug report, as I've

Re: [libreoffice-users] Mail Merge Crashes

2011-12-15 Thread Cor Nouws
Paul Rolfe wrote (15-12-11 22:21) It's Bug 43876, 43867 ;-) Thanks, clear report and confirmed. -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Mail Merge Crashes

2011-12-15 Thread Paul Rolfe
No Problem - glad you could reproduce it :) On 15/12/11 21:58, Cor Nouws wrote: Paul Rolfe wrote (15-12-11 22:21) It's Bug 43876, 43867 ;-) Thanks, clear report and confirmed. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

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

[libreoffice-users] Mail Merge Crashes

2011-12-11 Thread paul
Hi, 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 or print the document,

[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 are

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

2011-11-20 Thread David S. Crampton
This sounds to me like an e-mail processing issue; not an LO problem. What exactly is the evidence that some of the e-mails are not sent? How large is the document that you are trying to send? What is your e-mail environment? Your client? Your messaging server? What is your antivirus

Re: [libreoffice-users] Mail merge seems slow

2011-10-31 Thread Tom Davies
Edmonds steve.edmo...@ptglobal.com Subject: [libreoffice-users] Mail merge seems slow To: users@global.libreoffice.org Date: Monday, 31 October, 2011, 3:18 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

[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. Is this

  1   2   >