Macro script for sending mail from Calc

Creating a macro - Writing a Script - Using the API

Macro script for sending mail from Calc

Postby Haese005 » Sat Apr 29, 2017 11:52 am

Hello,
I am from the Netherlands and no one here seems not be able to help me :crazy: . My problem is that I am searching for the script for sending a email from a button (Verzenden) in a CALC spreadsheet. I am using Outlook as email client.
i want to send the spreadsheet with the subject name to 2 receivers. That's all!
Who can help me with this? I have put the spreadsheet in the attachment.
Greetz Wout
Attachments
DAGREGISTRATIE SNEL SCHOON ZUID-OOST NIEUWE STIJL 2 0.xlsm
(21.33 KiB) Downloaded 11 times
OpenOffice 4.13 and Operating system: Windows 10
Email Client: Outlook
Haese005
 
Posts: 4
Joined: Wed Mar 22, 2017 7:02 pm

Re: macro script for sending mail from calc

Postby Zizi64 » Sat Apr 29, 2017 11:59 am

I am using Outlook as email client.

1.: You need use a real Email client software like the Thunderbird.
(This process worked for me with the old Outlook Express software too in the far past time...)

2: You must rewrite all of your MS VBA macros, because THE MS VBA and the API of the AOO/LO are not compatible.
And use the International Standard ODF fileformats instead of the old fashioned binary .slx, or the "half standardized" .xlsx format. (The MS nor support the Strict version of the OOXML standard.
Last edited by Zizi64 on Sat Apr 29, 2017 1:56 pm, edited 1 time in total.
Tibor Kovacs, Hungary; LibreOffice4.4.7 - Portable versions: LO3.3.0-LO5.3.3 and AOO4.1.3; on Win7x64Prof.
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 5124
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: macro script for sending mail from calc

Postby Zizi64 » Sat Apr 29, 2017 12:02 pm

Tibor Kovacs, Hungary; LibreOffice4.4.7 - Portable versions: LO3.3.0-LO5.3.3 and AOO4.1.3; on Win7x64Prof.
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 5124
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: macro script for sending mail from calc

Postby Haese005 » Sat Apr 29, 2017 12:11 pm

Thanks Zizi64 for your super fast reaction! My problem is that the company I work for only want to use Outlook. Is it still possible ?
OpenOffice 4.13 and Operating system: Windows 10
Email Client: Outlook
Haese005
 
Posts: 4
Joined: Wed Mar 22, 2017 7:02 pm

Re: macro script for sending mail from calc

Postby Zizi64 » Sat Apr 29, 2017 12:41 pm

I never used the Outlook. I do not know anything about it.

Related topics:
https://forum.openoffice.org/en/forum/v ... 15&t=85307
https://forum.openoffice.org/en/forum/v ... 15&t=88192
Tibor Kovacs, Hungary; LibreOffice4.4.7 - Portable versions: LO3.3.0-LO5.3.3 and AOO4.1.3; on Win7x64Prof.
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 5124
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: macro script for sending mail from calc

Postby Haese005 » Sat Apr 29, 2017 1:08 pm

Again thanks Zizi64. I am going to try the options given in your links.
OpenOffice 4.13 and Operating system: Windows 10
Email Client: Outlook
Haese005
 
Posts: 4
Joined: Wed Mar 22, 2017 7:02 pm

Re: macro script for sending mail from calc

Postby Villeroy » Sat Apr 29, 2017 1:44 pm

This office suite comes with a full Python runtime. You can program anything you want in Python.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 23730
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Macros and UNO API

Who is online

Users browsing this forum: Majestic-12 [Bot] and 8 guests