Mailmerge in libreoffice: Difference between revisions

From DWIKI
mNo edit summary
mNo edit summary
 
Line 1: Line 1:
Sending mails from libreoffice takes several steps:
Sending mails from libreoffice takes several steps:


=Email settings=
= Email settings =
 
Are hidden under '''Tools->Options->Libreoffice Writer->Merge E-Mail''', fill in the settings as you do in any mail client. Keep in mind:
Are hidden under '''Tools->Options->Libreoffice Writer->Merge E-Mail''', fill in the settings as you do in any mail client. Keep in mind:
*The '''Test Settings''' dialog is broken, if your settings are correct it will show 2 "OK" lines, no errors and then just hangs there.T he Stop butting does not work, Cancel does.


=Create template=
*The '''Test Settings''' dialog is broken, if your settings are correct it will show 2 "OK" lines, no errors and then just hangs there.T he Stop butting does not work, Cancel does.
 
= Create template =
 
optonial?
optonial?


=Run Mail Merge Wizard=
= Run Mail Merge Wizard =
 
That's the envelope like icon top left or '''Tools->Mail Merge Wizard'''
That's the envelope like icon top left or '''Tools->Mail Merge Wizard'''


==Select document==
== Select document ==
 
The document to mail, probably the document you're currently working in.
The document to mail, probably the document you're currently working in.


==Document type==
== Document type ==
 
In this case email
In this case email


==Select Address List==
== Select Address List ==
 
Usually a spreadsheet containing at least a column called 'email' or something
Usually a spreadsheet containing at least a column called 'email' or something


==Create salutation==
== Create salutation ==
 
Can be skipped if the template/document you're sending already contains all that
Can be skipped if the template/document you're sending already contains all that


 
 


== Sending the mails ==
== Sending the mails ==
Line 32: Line 41:


If you can't find it, try Tool->Customize-Toolbars, look for "Send E-mail messages"
If you can't find it, try Tool->Customize-Toolbars, look for "Send E-mail messages"
= FAQ =
== date source was not found, please check the connection settings ==
libreoffice-base missing?
 
== name is already used for another database ==
another stupid message

Latest revision as of 16:14, 16 January 2022

Sending mails from libreoffice takes several steps:

Email settings

Are hidden under Tools->Options->Libreoffice Writer->Merge E-Mail, fill in the settings as you do in any mail client. Keep in mind:

  • The Test Settings dialog is broken, if your settings are correct it will show 2 "OK" lines, no errors and then just hangs there.T he Stop butting does not work, Cancel does.

Create template

optonial?

Run Mail Merge Wizard

That's the envelope like icon top left or Tools->Mail Merge Wizard

Select document

The document to mail, probably the document you're currently working in.

Document type

In this case email

Select Address List

Usually a spreadsheet containing at least a column called 'email' or something

Create salutation

Can be skipped if the template/document you're sending already contains all that

 

Sending the mails

That's the other envelop like icon, there you select to': the field called 'email' or whatever. Then fill inSubject, and then choose Send all documents or the range you want to send to.

 

If you can't find it, try Tool->Customize-Toolbars, look for "Send E-mail messages"

FAQ

date source was not found, please check the connection settings

libreoffice-base missing?

 

name is already used for another database

another stupid message