LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 08-25-2012, 07:28 AM   #1
gael33
Member
 
Registered: Feb 2009
Location: Scotland
Distribution: Linux Mint 18.0 Cinnamon 64 bit
Posts: 301

Rep: Reputation: 20
Question Mail Merge in Libre Office 3.6


I've just spent a full evening trying to set up Mail Merge in LibreOffice 3.6 without success.
Is there anyone on the board who has successfully set up Mail Merge, and if you have could you please help me to do the same.
I use Gmail as my email client.

Thank you,
gael.
 
Old 08-25-2012, 08:42 AM   #2
Ser Olmy
Senior Member
 
Registered: Jan 2012
Distribution: Slackware
Posts: 2,404

Rep: Reputation: Disabled
As you don't say exactly what you've done and how far you got, I may be telling you things you know already.

First, "Mail Merge" is traditionally a process where you stuff data from a data source (database, spreadsheet, whatever) into fields in a document, creating a number of identical-sounding letters to a list of recipients. We're talking physical letters here, as in documents that get printed out and stuffed into envelopes. Hence, if you do a Google search for "mail merge", the various tips and tutorials that turn up may not mention bulk e-mail functionality at all.

Second, your mail client is not Gmail. Your mail service may be Gmail, but in order to send bulk e-mails from an application, a mail client of some sort has to be involved. A web-based interface will not work.

Usually, bulk e-mails are sent using a locally installed mail client (Thunderbird, Outlook, whatever), not a Word Processor. In order to send bulk e-mails directly from LibreOffice, LibreOffice Writer would have to interact with the default mail client on your system, or act as an e-mail client itself. I was somewhat surprised to learn that Writer seems capable of doing the latter.

You asked if anyone has successfully done mail merge with e-mails in LibreOffice. I myself have not, but as there are specific settings in Writer for doing just that, it's probably possible.

If you were a bit more specific about what you've tried, you'd be more likely to get a response from someone who's actually done this (but who may not feel up to writing a 5-page tutorial in response to a non-specific inquiry).
 
1 members found this post helpful.
Old 08-25-2012, 09:42 AM   #3
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Distribution: UBUNTU 5.10 since Jul-18,2006 on Intel 820 DC
Posts: 805

Rep: Reputation: 186Reputation: 186
Hre's an example based on a small training I did for one of my clients some time back when they migrated from MS to OO. (I also used it in libre office).

Scenario. A form letter to employees regarding salary revision.
Input data : test_data.ods contains input data one record per row in a sheet called RevisionList
Form letter : test_data1.odt
Filled up form letter : test_data2.odt
Output : test_output.odt
Support file : mail_merge.pdf (downloaded instructions).

Steps:
  1. Prepare your data source (obviously).
  2. Register the data source (uses odb). This is one time. (Step 3 of tools->mailmergewizard)
  3. Create your empty form letter (test_data1.odt)
  4. Populate it (place cursor and) with the fields in the data source using Insert->Fields->Other->(tab)Database->MailMergeFields ... (Final0.jpg)
Open Tools->MailMergeWizard and select 8 save, print or send. (See Final1.jpg) for the options.

I find that I cant upload odt and ods files to LQ (why!?!?) and the pdf file is too big.

Hope this helps.

OK.
Attached Thumbnails
Click image for larger version

Name:	FINAL0.JPG
Views:	26
Size:	34.4 KB
ID:	10467   Click image for larger version

Name:	Final1.JPG
Views:	23
Size:	29.2 KB
ID:	10468   Click image for larger version

Name:	test_data2.odt.jpg
Views:	23
Size:	22.9 KB
ID:	10470  

Last edited by AnanthaP; 08-25-2012 at 09:55 AM.
 
1 members found this post helpful.
Old 08-25-2012, 10:22 AM   #4
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Distribution: UBUNTU 5.10 since Jul-18,2006 on Intel 820 DC
Posts: 805

Rep: Reputation: 186Reputation: 186
Ser_olmy.
Mail merge always meant that you
(a) Create a form letter.
(b) Keep your data in a data source.
(c) Link the fields in the form letter to the data source.
(d) Fire the print job.

Now using office packages like OO, you can
(a) register ODBC, mySql, ADO, Spreadsheet, text data etc etc as data sources.
(b) Output can be sent to a single file, multiple files, e-mail and of cource to your local printer.
(c) As you say, open office uses the locally installed mail client.

Attached is a sample of the e-mail option for sending. As you may have observed, the TO: fields is populated form the data source.

OK
Attached Thumbnails
Click image for larger version

Name:	Sample.JPG
Views:	20
Size:	44.4 KB
ID:	10471  
 
1 members found this post helpful.
Old 08-25-2012, 10:59 AM   #5
gael33
Member
 
Registered: Feb 2009
Location: Scotland
Distribution: Linux Mint 18.0 Cinnamon 64 bit
Posts: 301

Original Poster
Rep: Reputation: 20
Thank you all for your help and recommendations. I will try them later when I have more time.

Thanks,

gael.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] fluxbox can't see my libre office window benslice Linux - Desktop 2 07-02-2012 06:58 PM
libre office take up whole window. casperdaghost Linux - Newbie 4 02-04-2012 09:44 AM
Libre Office database jdtiede Linux - Software 1 12-11-2011 05:22 AM
install libre office mposwal Slackware 12 11-03-2011 08:34 PM
LXer: Libre Office Initial plans for the free office suite [German] LXer Syndicated Linux News 2 11-14-2010 06:14 PM


All times are GMT -5. The time now is 04:40 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration