Documentation/How Tos/Doing an Email Mail Merge

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 09:39, 10 March 2009 by Mwaller (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The Mail Merge Wizard is a bit complicated.So it is better to "roll your own" when making a mail merge document (see Creating Mail Merge Documents From Text/CSV or Spreadsheets)

Everything you can do in the mail merge wizard, you can pretty much do in the roll-your-own approach, except an email mail merge. But do you really want to go through the complexity and muscle aches of using the Mail Merge Wizard? No. And you do not have to. You are going to mix and match.

  1. Create your email the way you want it with the roll-your-own approach.
  2. example

  3. Save it. But keep it open.
  4. In Writer set up email configuration. Choose Tools > Options > Writer > Email. Key settings are the outgoing server name and the port number. You just need to do this once. If you have security on your email, like requiring a password to send, you will have to click the Server Authentication button and enter additional information.
  5. Toolsoptions

  6. Choose Tools > Mail Merge Wizard and check Use the Current Document. Or else browse to your document, and click Next.
  7. Choose E-mail message and click Next.
  8. Select the database you are using and the table. Click OK and click Next.
  9. Mmw3

  10. Keep clicking Next until you are here. Fill it in by selecting the field from the database that has the emails in it, and anything else you want. Click Send Documents. Mmw4send You will see the progress window. And you are done!

The received email looks like this. Note that I sent it in email format, but with the extra carriage returns I put between the lines in Writer, it looks a little spacey here. You will want to experiment with and adjust how you format the original Writer documents and what format you send in.

Personal tools