Code to send an email from Lotus Notes

C

chrissmarlow

Board Regular
Joined
Jun 3, 2010
Messages
59
Hi,

I have a macro in excel, when it finishes running (takes about 20 minutes) I would like it to send an email automaticly from Lotus Notes to a couple of different email addresses just with "Complete - current date" as the subject and with no body. Can someone provide me with simple code to do this???

My VB knowledge is very very basic ;)
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

J
  • Solved
Automatically sending email from a shared mailbox via an Excel macro
Replies
1
Views
745
Jeff Leubecker
J
J
  • Question
VBA code to send an email if a certain IF Criteria is met that loops when the spreadsheet is open
Replies
1
Views
237
joeyc123
J
T
  • Solved
Sending daily emails based on criteria, with email body corresponding to parallel cell which holds email address(es)
Replies
1
Views
773
twinwings
T
D
  • Question
send an email notification when the value of the cell is selected in the drop down as Completed.
Replies
0
Views
234
danielz86
D
T
  • Solved
Auto Email list
Replies
2
Views
382
Tablecloth98
T

Forum statistics

Threads
1,214,925
Messages
6,122,303
Members
449,078
Latest member
nonnakkong

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top