I need a macro that can attach a macro enabled Excel workbook to either Microsoft Outlook or Lotus Notes and send the email to the recipient. Once received, the recipient will add information to the workbook using other in-built macros, save it, and the return it to the originator. The originator and the recipient will not always be the same person.
To keep things simple, I would like to use one "Send" button. I'd also like to have the user select which email system is being used at his or her end, i.e. Lotus Notes or Microsoft Outlook. I'd also like the user to be prompted to input the email address of the person to receive the email (with the attached Excel workbook) using an input box.
So the macro must be able to:
Prompt the user to select which email system is to be used (Outlook or Lotus Notes)
Prompt the user to input the recipients email address
Attach the macro enabled Excel spreadsheet to the email
Send the email to the recipient
The macro must be able to work at both the originator and recipient ends.
Can anyone help?
Bookmarks