Page 1 of 1
Macro script for sending mail from Calc
Posted: Sat Apr 29, 2017 11:52 am
by Haese005
Hello,
I am from the Netherlands and no one here seems not be able to help me
. 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
Re: macro script for sending mail from calc
Posted: Sat Apr 29, 2017 11:59 am
by Zizi64
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.
Re: macro script for sending mail from calc
Posted: Sat Apr 29, 2017 12:02 pm
by Zizi64
Re: macro script for sending mail from calc
Posted: Sat Apr 29, 2017 12:11 pm
by Haese005
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 ?
Re: macro script for sending mail from calc
Posted: Sat Apr 29, 2017 12:41 pm
by Zizi64
I never used the Outlook. I do not know anything about it.
Related topics:
viewtopic.php?f=15&t=85307
viewtopic.php?f=15&t=88192
Re: macro script for sending mail from calc
Posted: Sat Apr 29, 2017 1:08 pm
by Haese005
Again thanks Zizi64. I am going to try the options given in your links.
Re: macro script for sending mail from calc
Posted: Sat Apr 29, 2017 1:44 pm
by Villeroy
This office suite comes with a full Python runtime. You can program anything you want in Python.