![]() ![]() If the data source contains email addresses, you can also use mail merge to send a document to multiple addressees by email. For example you can issue multiple certificates for a school using a certificate template and data containing the student names. Mail Merge was first used to produce mailing letters but has multiple applications as well. Mail merge solves this problem by allowing us to make multiple copies of a document and automatically inserting data from a source to certain parts of the document. However this process becomes tedious and time consuming for a larger number of customer entries. Instead of sending the same letter to all customers, the business owner wants to personalize the document by addressing each customer by his/her title, First and Last Name.įor a small number of customers the owner can simply copy and paste the text and change only the Title and Name for each customer. The letter is a document containing the company information and some standard text. To better understand what is mail merge let's examine the following scenario.Ī business owner wants to send a newsletter to all the customers to promote a new product. : (503, '5.5.2 Send hello first ', u', traceback followsĬ:\Program Files (x86)\OpenOffice 4\program\mailmerge.Mail Merge is LibreOffice tool that allows us to produce multiple documents from a single document using a data source. : (503, '5.5.2 Send hello first ', u' traceback followsĬ:\Program Files (x86)\OpenOffice 4\program\python-core-2.7.6\lib\smtplib.py:724 in function sendmail() Īttempt to send email #3 resulted in the following message Task window shows RED X and Sending to: : (501, '5.5.4 Invalid domain name '), traceback followsĬ:\Program Files (x86)\OpenOffice 4\program\python-core-2.7.6\lib\smtplib.py:538 in function ehlo_or_helo_if_needed() Ĭ:\Program Files (x86)\OpenOffice 4\program\python-core-2.7.6\lib\smtplib.py:711 in function sendmail() Ĭ:\Program Files (x86)\OpenOffice 4\program\mailmerge.py:267 in function sendMailMessage() Īttempt to send email #2 resulted in the following message Transfer status - 1 e-mails sent - Sending Paused Sending E-mail messages Window opens and displays the following:Ĭonnection Status - The connection to the outgoing mail server had been established Save, print or send = "Send merged document as E-Mail", in E-Mail settings entered "address" in "To" field and "test" in "Email settings" "Subject" field Personalize Document = no actions takenĨ. Adjust layout (selection was greyed out-possibly due to this being an email?)ħ. Create Salutation = left box unchecked-no salutationĥ. Select address list = selected "Select Address List." button, selected Calc spreadsheet that includes and data for 3 test email addressĤ. Select document type = "E-mail message"ģ. Select starting document = "start from existing document" (selected writer document with and fields and static verbiageĢ. Note: In the Calc spreadsheet the 1st and 3rd email address is set as html link and the 2nd email address set as text.ġ. Test Setting (using "Test Settings." button) exercise resulted in all Green "Establish network connection" = Successful "Find outgoing mail server" = SuccessfulĬompleted a test email merge using the Writer email merge steps (using a Calc spreadsheet to hold email and, created a Writer document that includes the and firstname> fields) and some static verbiage. Left unchecked the box for selection - "The outgoing mail server (SMTP) requires authentication" Went to tools, options, openoffice writer, mail merge e-mail section and entered the following:Į-Mail Address - server (SMTP) Settings What I have tried so far, and the associated error messages I have received include: Let me know if additional information is needed to help solve this issue, and any solutions for a fix. I am running this on Windows 10 operating system. I appreciate any help to configure OpenOffice Writer (version 4.1.6, Build 9790) to eMail merge with my (the free version, also called "Microsoft Mail").
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |