Applescript from vba doesn't send mail
0
I have VBA code in Excel. Code generates applescript and run with MacScript (scriptToRun).
Generated applescript:
tell application "Mail"
set NewMail to make new outgoing message with properties {content:"Тестовая Заявка", subject:"Заявка" , visible:true}
tell NewMail
make new to recipient at end of to recipients with properties {address:"myaddress@gmail.com"}
tell content of NewMail
make new attachment with properties {file name:"Macintosh HDD:Users:xxxxx:order_26.11.2018_005345.xlsx" as alias} at after the last paragraph
end tell
activate
delay 3
end tell
Activate
send NewMail
end tell
Mail display, but do not send. If I try this script with MAC script editor all be ok and mail send.
VBA return error 5: invalid procedure call or argument
Where I wrong?
P.S.sorry for bad English
excel vba applescript
edited Nov 25 '18 at 22:04
Robert Harvey♦
149k33276420
asked Nov 25 '18 at 22:02
AlexanderAlexander
1
add a comment |
0
I have VBA code in Excel. Code generates applescript and run with MacScript (scriptToRun).
Generated applescript:
tell application "Mail"
set NewMail to make new outgoing message with properties {content:"Тестовая Заявка", subject:"Заявка" , visible:true}
tell NewMail
make new to recipient at end of to recipients with properties {address:"myaddress@gmail.com"}
tell content of NewMail
make new attachment with properties {file name:"Macintosh HDD:Users:xxxxx:order_26.11.2018_005345.xlsx" as alias} at after the last paragraph
end tell
activate
delay 3
end tell
Activate
send NewMail
end tell
Mail display, but do not send. If I try this script with MAC script editor all be ok and mail send.
VBA return error 5: invalid procedure call or argument
Where I wrong?
P.S.sorry for bad English
excel vba applescript
edited Nov 25 '18 at 22:04
Robert Harvey♦
149k33276420
asked Nov 25 '18 at 22:02
AlexanderAlexander
1
Which line of code caused the error?
– Robert Harvey♦
Nov 25 '18 at 22:05
What is the content of your variable ScriptToRun in your VBA MacScript ? It must be the complete path to your script file and this syntax is only valid for Excel < 2016. For Excel 2016, call of Applescript from VBA is done via AppleScriptTask. More details here -> link
– pbell
Nov 26 '18 at 6:29
error in this line MacScript (scriptToRun) but mail display with attachment
– Alexander
Nov 26 '18 at 21:02
using Excel 2016 AppleScriptTask return same error. I tried this method. Script file in Library:Application scripts:com.microsoft.excel Now I call script with MacScript method contet of ScriptToRun in question: tell application "Mail" set NewMail to make new outgoing message with properties {content:"Тестовая Заявка", subject:"Заявка" , visible:true} tell NewMail make new to recipient at end of to recipients with properties {address:"myaddress@gmail.com"} tell content of NewMail ....
– Alexander
Nov 26 '18 at 22:00
add a comment |
0
0
0
I have VBA code in Excel. Code generates applescript and run with MacScript (scriptToRun).
Generated applescript:
tell application "Mail"
set NewMail to make new outgoing message with properties {content:"Тестовая Заявка", subject:"Заявка" , visible:true}
tell NewMail
make new to recipient at end of to recipients with properties {address:"myaddress@gmail.com"}
tell content of NewMail
make new attachment with properties {file name:"Macintosh HDD:Users:xxxxx:order_26.11.2018_005345.xlsx" as alias} at after the last paragraph
end tell
activate
delay 3
end tell
Activate
send NewMail
end tell
Mail display, but do not send. If I try this script with MAC script editor all be ok and mail send.
VBA return error 5: invalid procedure call or argument
Where I wrong?
P.S.sorry for bad English
excel vba applescript
edited Nov 25 '18 at 22:04
Robert Harvey♦
149k33276420
asked Nov 25 '18 at 22:02
AlexanderAlexander
1
I have VBA code in Excel. Code generates applescript and run with MacScript (scriptToRun).
Generated applescript:
tell application "Mail"
set NewMail to make new outgoing message with properties {content:"Тестовая Заявка", subject:"Заявка" , visible:true}
tell NewMail
make new to recipient at end of to recipients with properties {address:"myaddress@gmail.com"}
tell content of NewMail
make new attachment with properties {file name:"Macintosh HDD:Users:xxxxx:order_26.11.2018_005345.xlsx" as alias} at after the last paragraph
end tell
activate
delay 3
end tell
Activate
send NewMail
end tell
Mail display, but do not send. If I try this script with MAC script editor all be ok and mail send.
VBA return error 5: invalid procedure call or argument
Where I wrong?
P.S.sorry for bad English
excel vba applescript
excel vba applescript
edited Nov 25 '18 at 22:04
Robert Harvey♦
149k33276420
asked Nov 25 '18 at 22:02
AlexanderAlexander
1
edited Nov 25 '18 at 22:04
Robert Harvey♦
149k33276420
asked Nov 25 '18 at 22:02
AlexanderAlexander
1
edited Nov 25 '18 at 22:04
Robert Harvey♦
149k33276420
edited Nov 25 '18 at 22:04
Robert Harvey♦
149k33276420
edited Nov 25 '18 at 22:04
Robert Harvey♦
149k33276420
149k33276420
asked Nov 25 '18 at 22:02
AlexanderAlexander
1
asked Nov 25 '18 at 22:02
AlexanderAlexander
1
asked Nov 25 '18 at 22:02
AlexanderAlexander
1
1
Which line of code caused the error?
– Robert Harvey♦
Nov 25 '18 at 22:05
What is the content of your variable ScriptToRun in your VBA MacScript ? It must be the complete path to your script file and this syntax is only valid for Excel < 2016. For Excel 2016, call of Applescript from VBA is done via AppleScriptTask. More details here -> link
– pbell
Nov 26 '18 at 6:29
error in this line MacScript (scriptToRun) but mail display with attachment
– Alexander
Nov 26 '18 at 21:02
using Excel 2016 AppleScriptTask return same error. I tried this method. Script file in Library:Application scripts:com.microsoft.excel Now I call script with MacScript method contet of ScriptToRun in question: tell application "Mail" set NewMail to make new outgoing message with properties {content:"Тестовая Заявка", subject:"Заявка" , visible:true} tell NewMail make new to recipient at end of to recipients with properties {address:"myaddress@gmail.com"} tell content of NewMail ....
– Alexander
Nov 26 '18 at 22:00
add a comment |
Which line of code caused the error?
– Robert Harvey♦
Nov 25 '18 at 22:05
What is the content of your variable ScriptToRun in your VBA MacScript ? It must be the complete path to your script file and this syntax is only valid for Excel < 2016. For Excel 2016, call of Applescript from VBA is done via AppleScriptTask. More details here -> link
– pbell
Nov 26 '18 at 6:29
error in this line MacScript (scriptToRun) but mail display with attachment
– Alexander
Nov 26 '18 at 21:02
using Excel 2016 AppleScriptTask return same error. I tried this method. Script file in Library:Application scripts:com.microsoft.excel Now I call script with MacScript method contet of ScriptToRun in question: tell application "Mail" set NewMail to make new outgoing message with properties {content:"Тестовая Заявка", subject:"Заявка" , visible:true} tell NewMail make new to recipient at end of to recipients with properties {address:"myaddress@gmail.com"} tell content of NewMail ....
– Alexander
Nov 26 '18 at 22:00
Which line of code caused the error?
– Robert Harvey♦
Nov 25 '18 at 22:05
Which line of code caused the error?
– Robert Harvey♦
Nov 25 '18 at 22:05
What is the content of your variable ScriptToRun in your VBA MacScript ? It must be the complete path to your script file and this syntax is only valid for Excel < 2016. For Excel 2016, call of Applescript from VBA is done via AppleScriptTask. More details here -> link
– pbell
Nov 26 '18 at 6:29
What is the content of your variable ScriptToRun in your VBA MacScript ? It must be the complete path to your script file and this syntax is only valid for Excel < 2016. For Excel 2016, call of Applescript from VBA is done via AppleScriptTask. More details here -> link
– pbell
Nov 26 '18 at 6:29
error in this line MacScript (scriptToRun) but mail display with attachment
– Alexander
Nov 26 '18 at 21:02
error in this line MacScript (scriptToRun) but mail display with attachment
– Alexander
Nov 26 '18 at 21:02
using Excel 2016 AppleScriptTask return same error. I tried this method. Script file in Library:Application scripts:com.microsoft.excel Now I call script with MacScript method contet of ScriptToRun in question: tell application "Mail" set NewMail to make new outgoing message with properties {content:"Тестовая Заявка", subject:"Заявка" , visible:true} tell NewMail make new to recipient at end of to recipients with properties {address:"myaddress@gmail.com"} tell content of NewMail ....
– Alexander
Nov 26 '18 at 22:00
using Excel 2016 AppleScriptTask return same error. I tried this method. Script file in Library:Application scripts:com.microsoft.excel Now I call script with MacScript method contet of ScriptToRun in question: tell application "Mail" set NewMail to make new outgoing message with properties {content:"Тестовая Заявка", subject:"Заявка" , visible:true} tell NewMail make new to recipient at end of to recipients with properties {address:"myaddress@gmail.com"} tell content of NewMail ....
– Alexander
Nov 26 '18 at 22:00
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53472455%2fapplescript-from-vba-doesnt-send-mail%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53472455%2fapplescript-from-vba-doesnt-send-mail%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Which line of code caused the error?
– Robert Harvey♦
Nov 25 '18 at 22:05
What is the content of your variable ScriptToRun in your VBA MacScript ? It must be the complete path to your script file and this syntax is only valid for Excel < 2016. For Excel 2016, call of Applescript from VBA is done via AppleScriptTask. More details here -> link
– pbell
Nov 26 '18 at 6:29
error in this line MacScript (scriptToRun) but mail display with attachment
– Alexander
Nov 26 '18 at 21:02
using Excel 2016 AppleScriptTask return same error. I tried this method. Script file in Library:Application scripts:com.microsoft.excel Now I call script with MacScript method contet of ScriptToRun in question: tell application "Mail" set NewMail to make new outgoing message with properties {content:"Тестовая Заявка", subject:"Заявка" , visible:true} tell NewMail make new to recipient at end of to recipients with properties {address:"myaddress@gmail.com"} tell content of NewMail ....
– Alexander
Nov 26 '18 at 22:00