Mailmerge in libreoffice: Difference between revisions
(Created page with "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 i...") |
mNo edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| 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 = | |||
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 | |||
The document to mail, probably the document you're currently working in. | |||
== 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 == | |||
That's the other envelop like icon, there you select '''to''': the field called 'email' or whatever. Then fill in'''''<i>Subject</i>, 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 | |||
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
