I have a spreadsheet which I have sorted and formatted using basic macros. The user pastes raw data in the sheet and clicks a button. The macros will then sort and format it and save the formatted file in a particular location using a particular name. I need to know how to send this file, along with 3 other files (word and excel files) as attachments using a Novell Groupwise Client. There is a fixed contact list, subject title and message body. However I cannot inlcude any of this data (contact list, subject etc) in the original spreadsheet file.
I do not know how to access email clients through excel VBA so any help will be greatly appreciated.
Thanks