How do I add a second attachment to this VBA code for Excel? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!How to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?Is there a way to crack the password on an Excel VBA Project?How to avoid using Select in Excel VBAExcel VBA Sending emails with multiple attachementsExcel VBA - Send Email via CDO.message - cannot add attachmentSending email attachments from Excel via VBACreate new attachments Excel-VBAAttaching unsaved excel file to email VBASend only those emails that have attachments by way of a VBA codeVBA to attach excel file as attachment and to have worksheet in the body of email
Can humans save crash-landed aliens?
One-one communication
Why complex landing gears are used instead of simple,reliability and light weight muscle wire or shape memory alloys?
Simple Line in LaTeX Help!
Is there any word for a place full of confusion?
Nose gear failure in single prop aircraft: belly landing or nose-gear up landing?
Constant factor of an array
Does silver oxide react with hydrogen sulfide?
What initially awakened the Balrog?
If Windows 7 doesn't support WSL, then what is "Subsystem for UNIX-based Applications"?
Can an iPhone 7 be made to function as a NFC Tag?
Flight departed from the gate 5 min before scheduled departure time. Refund options
Should a wizard buy fine inks every time he want to copy spells into his spellbook?
Why is it faster to reheat something than it is to cook it?
How does TikZ render an arc?
A term for a woman complaining about things/begging in a cute/childish way
Caught masturbating at work
Is there hard evidence that the grant peer review system performs significantly better than random?
Was Kant an Intuitionist about mathematical objects?
Why BitLocker does not use RSA
How many time has Arya actually used Needle?
GDP with Intermediate Production
How to ask rejected full-time candidates to apply to teach individual courses?
Google .dev domain strangely redirects to https
How do I add a second attachment to this VBA code for Excel?
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!How to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?Is there a way to crack the password on an Excel VBA Project?How to avoid using Select in Excel VBAExcel VBA Sending emails with multiple attachementsExcel VBA - Send Email via CDO.message - cannot add attachmentSending email attachments from Excel via VBACreate new attachments Excel-VBAAttaching unsaved excel file to email VBASend only those emails that have attachments by way of a VBA codeVBA to attach excel file as attachment and to have worksheet in the body of email
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Screen Shot of Code
Hi there, I'm an absolute novice at coding, and this is not my own work, but I was just looking to add a second attachment to this piece of code for sending out emails via excel. Any help would be really appreciated. Thanks.
excel vba email
asked Mar 22 at 12:00
Robert EdgeRobert Edge
31
add a comment |
Screen Shot of Code
Hi there, I'm an absolute novice at coding, and this is not my own work, but I was just looking to add a second attachment to this piece of code for sending out emails via excel. Any help would be really appreciated. Thanks.
excel vba email
asked Mar 22 at 12:00
Robert EdgeRobert Edge
31
1
Please add your code as text, not image.
– Marvin Klar
Mar 22 at 12:04
idownvotedbecau.se/imageofcode
– Diogo Rocha
Mar 22 at 12:06
add a comment |
Screen Shot of Code
Hi there, I'm an absolute novice at coding, and this is not my own work, but I was just looking to add a second attachment to this piece of code for sending out emails via excel. Any help would be really appreciated. Thanks.
excel vba email
asked Mar 22 at 12:00
Robert EdgeRobert Edge
31
Screen Shot of Code
Hi there, I'm an absolute novice at coding, and this is not my own work, but I was just looking to add a second attachment to this piece of code for sending out emails via excel. Any help would be really appreciated. Thanks.
excel vba email
excel vba email
asked Mar 22 at 12:00
Robert EdgeRobert Edge
31
asked Mar 22 at 12:00
Robert EdgeRobert Edge
31
asked Mar 22 at 12:00
Robert EdgeRobert Edge
31
asked Mar 22 at 12:00
Robert EdgeRobert Edge
31
asked Mar 22 at 12:00
Robert EdgeRobert Edge
31
31
1
Please add your code as text, not image.
– Marvin Klar
Mar 22 at 12:04
idownvotedbecau.se/imageofcode
– Diogo Rocha
Mar 22 at 12:06
add a comment |
1
Please add your code as text, not image.
– Marvin Klar
Mar 22 at 12:04
idownvotedbecau.se/imageofcode
– Diogo Rocha
Mar 22 at 12:06
1
1
Please add your code as text, not image.
– Marvin Klar
Mar 22 at 12:04
Please add your code as text, not image.
– Marvin Klar
Mar 22 at 12:04
idownvotedbecau.se/imageofcode
– Diogo Rocha
Mar 22 at 12:06
idownvotedbecau.se/imageofcode
– Diogo Rocha
Mar 22 at 12:06
add a comment |
1 Answer
1
active
oldest
votes
The line msg.attachments.Add sh.Range("E" & i).Value adds the attachment. So the msg.attachments.Add is the command to add the attachment. And sh.Range("E" & i).Value is the argument of the command. Since sh is the workbook sheet, the sh.Range("E" & i) gets a range of cells in the worksheet and the .Value gets the values of these cells.
answered Mar 22 at 12:07
Marvin KlarMarvin Klar
6621424
Thanks for the response. I managed to alter it. It works!! Thanks for breaking it down for me!
– Robert Edge
Mar 22 at 12:33
Great to hear that! Feel free to upvote and mark the answer as accepted.
– Marvin Klar
Mar 22 at 12:43
Because I have less than 15 reputation points it doesn't seem to be letting me give you an up vote. Sorry about that.
– Robert Edge
Mar 22 at 14:08
add a comment |
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
);
);
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%2f55299177%2fhow-do-i-add-a-second-attachment-to-this-vba-code-for-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The line msg.attachments.Add sh.Range("E" & i).Value adds the attachment. So the msg.attachments.Add is the command to add the attachment. And sh.Range("E" & i).Value is the argument of the command. Since sh is the workbook sheet, the sh.Range("E" & i) gets a range of cells in the worksheet and the .Value gets the values of these cells.
answered Mar 22 at 12:07
Marvin KlarMarvin Klar
6621424
Thanks for the response. I managed to alter it. It works!! Thanks for breaking it down for me!
– Robert Edge
Mar 22 at 12:33
Great to hear that! Feel free to upvote and mark the answer as accepted.
– Marvin Klar
Mar 22 at 12:43
Because I have less than 15 reputation points it doesn't seem to be letting me give you an up vote. Sorry about that.
– Robert Edge
Mar 22 at 14:08
add a comment |
The line msg.attachments.Add sh.Range("E" & i).Value adds the attachment. So the msg.attachments.Add is the command to add the attachment. And sh.Range("E" & i).Value is the argument of the command. Since sh is the workbook sheet, the sh.Range("E" & i) gets a range of cells in the worksheet and the .Value gets the values of these cells.
answered Mar 22 at 12:07
Marvin KlarMarvin Klar
6621424
Thanks for the response. I managed to alter it. It works!! Thanks for breaking it down for me!
– Robert Edge
Mar 22 at 12:33
Great to hear that! Feel free to upvote and mark the answer as accepted.
– Marvin Klar
Mar 22 at 12:43
Because I have less than 15 reputation points it doesn't seem to be letting me give you an up vote. Sorry about that.
– Robert Edge
Mar 22 at 14:08
add a comment |
The line msg.attachments.Add sh.Range("E" & i).Value adds the attachment. So the msg.attachments.Add is the command to add the attachment. And sh.Range("E" & i).Value is the argument of the command. Since sh is the workbook sheet, the sh.Range("E" & i) gets a range of cells in the worksheet and the .Value gets the values of these cells.
answered Mar 22 at 12:07
Marvin KlarMarvin Klar
6621424
The line msg.attachments.Add sh.Range("E" & i).Value adds the attachment. So the msg.attachments.Add is the command to add the attachment. And sh.Range("E" & i).Value is the argument of the command. Since sh is the workbook sheet, the sh.Range("E" & i) gets a range of cells in the worksheet and the .Value gets the values of these cells.
answered Mar 22 at 12:07
Marvin KlarMarvin Klar
6621424
answered Mar 22 at 12:07
Marvin KlarMarvin Klar
6621424
answered Mar 22 at 12:07
Marvin KlarMarvin Klar
6621424
answered Mar 22 at 12:07
Marvin KlarMarvin Klar
6621424
6621424
Thanks for the response. I managed to alter it. It works!! Thanks for breaking it down for me!
– Robert Edge
Mar 22 at 12:33
Great to hear that! Feel free to upvote and mark the answer as accepted.
– Marvin Klar
Mar 22 at 12:43
Because I have less than 15 reputation points it doesn't seem to be letting me give you an up vote. Sorry about that.
– Robert Edge
Mar 22 at 14:08
add a comment |
Thanks for the response. I managed to alter it. It works!! Thanks for breaking it down for me!
– Robert Edge
Mar 22 at 12:33
Great to hear that! Feel free to upvote and mark the answer as accepted.
– Marvin Klar
Mar 22 at 12:43
Because I have less than 15 reputation points it doesn't seem to be letting me give you an up vote. Sorry about that.
– Robert Edge
Mar 22 at 14:08
Thanks for the response. I managed to alter it. It works!! Thanks for breaking it down for me!
– Robert Edge
Mar 22 at 12:33
Thanks for the response. I managed to alter it. It works!! Thanks for breaking it down for me!
– Robert Edge
Mar 22 at 12:33
Great to hear that! Feel free to upvote and mark the answer as accepted.
– Marvin Klar
Mar 22 at 12:43
Great to hear that! Feel free to upvote and mark the answer as accepted.
– Marvin Klar
Mar 22 at 12:43
Because I have less than 15 reputation points it doesn't seem to be letting me give you an up vote. Sorry about that.
– Robert Edge
Mar 22 at 14:08
Because I have less than 15 reputation points it doesn't seem to be letting me give you an up vote. Sorry about that.
– Robert Edge
Mar 22 at 14:08
add a comment |
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.
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%2f55299177%2fhow-do-i-add-a-second-attachment-to-this-vba-code-for-excel%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
1
Please add your code as text, not image.
– Marvin Klar
Mar 22 at 12:04
idownvotedbecau.se/imageofcode
– Diogo Rocha
Mar 22 at 12:06