Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 360
Default Sending Mail from Lotus Notes

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail über Lotus Notes aus Excel heraus/ Sending Mail with Excel through Lotus Notes [email protected] Excel Programming 0 February 19th 07 12:11 PM
Help sending Lotus Notes mail through VBA - one last piece! skiloa Excel Programming 0 June 9th 05 03:37 PM
Sending e-mail with Lotus Notes pressing an excel button AndyOne Excel Discussion (Misc queries) 0 June 1st 05 09:29 PM
VBA sending e-mail using Lotus Notes? Don Wiss Excel Programming 1 February 16th 05 02:46 AM
Sending Mail using Lotus Notes Frank Kabel Excel Programming 2 February 27th 04 04:28 PM


All times are GMT +1. The time now is 02:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"