Discussions Populaires Dans la Communauté Global Macro

Excel macro email notification‎

Macro that send email notification if the exel file(s) is/are modified‎

Réponses:

2

Adeptes:

2

Vues:

311

Vote Count:

0

 

La répondre a été ajoutée par  FITAH MOHAMED, Financial Manager, FUEL AND ENERGY CO for transportion petroleum materials
Depuis 8 années

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel As Boolean) Dim answer As String answer = MsgBox("This is where you put the text ... Voir Plus

 

La répondre a été ajoutée par  Firas Shahadi , Training And Development Director, Muhayal Assir National Hospital
Depuis 6 années

sending email is easy. but to send an email every time the sheet changed, you need to think about it.   to send the work book check this web site here