View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Li Bill Li is offline
external usenet poster
 
Posts: 46
Default vba macro in Excel

Hi Jodie,

You can record the macro and then modify it.
Following is a example

ActiveWorkbook.SendMail recipients:="Jean Selva"

Best Regards

Bill
-----Original Message-----
Hi,

I am creating macro code that would automatically send my
excel file (after editing) to an Email using Lotus Notes
R5 with the following parameters: SERVER, FROM, TO, CC,
BCC, SUBJECT, MESSAGES and ATTACHMENT, Can anyone give

me
some tips or ideas how to figure out this one.

Thanking you in advance.
Jodie

.