Mailmerge in libreoffice: Difference between revisions
m (Tony moved page Mailmerg in libreoffice to Mailmerge in libreoffice: Typo) |
mNo edit summary |
||
(One intermediate revision 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: | ||
=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 == | |||
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