W
ward376
I'm using code to send sheets as attachments using code from XL Dennis
- http://excelkb.com/article.aspx?id=10221&cNode=1X5M7A
The line .Send 0, vaRecipients sends the email. Is there a way to
display the created email with hard-coded recipients and attachment in
the event that the user would like to send to additional(ad-hoc)
recipients or add comments to the body?
I've tried stopping the code directly before the send line, but I
don't see any created email, then once the line is tripped, the email
is already sent.
I'm perfectly happy with users forwarding to other recipients and/or
adding commentary from the copy in their sent folders; this is a
request from a user and I expect my boss to make it official soon.
Thanks!
Cliff Edwards
- http://excelkb.com/article.aspx?id=10221&cNode=1X5M7A
The line .Send 0, vaRecipients sends the email. Is there a way to
display the created email with hard-coded recipients and attachment in
the event that the user would like to send to additional(ad-hoc)
recipients or add comments to the body?
I've tried stopping the code directly before the send line, but I
don't see any created email, then once the line is tripped, the email
is already sent.
I'm perfectly happy with users forwarding to other recipients and/or
adding commentary from the copy in their sent folders; this is a
request from a user and I expect my boss to make it official soon.
Thanks!
Cliff Edwards