ExcelBanter - vba macro in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - vba macro in Excel (https://www.excelbanter.com/excel-programming/275593-vba-macro-excel.html)

Jodie[_2_]

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

Bill Li

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

.

mcm

vba macro in Excel

Although i haven't tried your code, will it also work on lotus notes
4.6?

All times are GMT +1. The time now is 05:42 AM.