Mailmerge in libreoffice: Difference between revisions
From DWIKI
m (→Email settings) |
|||
Line 3: | Line 3: | ||
=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''' 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. | *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= | =Create template= |
Revision as of 18:04, 5 January 2020
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 in Subject, and then choose Send all documents or the range you want to send to.