Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba macro in Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba macro in Excel
Although i haven't tried your code, will it also work on lotus notes
4.6? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) |