Create a macro based on a range of cells in excel and send via Lotus Notes

[kmclaugh]

Hi, I am in desperate need of trying to figure out how to create a macro based on a range of cells in excel. I am fairly new with creating macros, so I have been working on this for over 3 months now. I have been reading through all the threads on the forum, and still have not been able create the macro correctly

I have data in columns A through AD and have about 500 rows on my report. I need to run the report every month and send an email to anyone that has data greater than or equal to 6. If column "W" is greater than or equal to 6, then click a "send emails" button with an attachment of the worksheet to email recipients in column "P" via Lotus Notes. (There would be multiple addresses, and each month would be different depending on the criteria.) Also if the criteria does not match the 6, then delete the row, and always save a copy of the worksheet to my "C" drive. Any help on this would be greatly appreciated!

Kim

[kmclaugh]

Hi, I am still trying to figure out how to get excel to send an email to multiple recipients in lotus notes with a criteria range. If column "W" is greater than or equal to 6, then send an email to recipients in column "P". Please, any help would be greatly appreciated. Thanks.

[kmclaugh]

Attached is the code that I have been using to figure this out. As you can see, I am now driving blind on figuring this out. Please can someone help me understand where I am going wrong.

Please Login or Register  to view this content.