Mailmerge in libreoffice - Revision history

Tony at 15:14, 16 January 2022

2022-01-16T15:14:06Z

← Older revision		Revision as of 15:14, 16 January 2022
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

Tony at 15:31, 5 June 2021

2021-06-05T15:31:16Z

← Older revision		Revision as of 15:31, 5 June 2021
Line 24:		Line 24:


	==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.		== 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"

Tony: Tony moved page Mailmerg in libreoffice to Mailmerge in libreoffice: Typo

2020-01-05T17:05:19Z

Tony moved page Mailmerg in libreoffice to Mailmerge in libreoffice: Typo

← Older revision		Revision as of 17:05, 5 January 2020
(No difference)

Tony: /* Email settings */

2020-01-05T17:04:05Z

Email settings

← Older revision		Revision as of 17:04, 5 January 2020
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=

Tony: /* Select document */

2020-01-05T17:03:47Z

Select document

← Older revision		Revision as of 17:03, 5 January 2020
Line 14:		Line 14:

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

	==Document type==		==Document type==

Tony: 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..."

2020-01-05T17:03:08Z

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..."

New page

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''' 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

==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.