Devon Hill
New Member
- Joined
- Aug 6, 2002
- Messages
- 28
Hi everybody. I'm looking for some code that will automatically start a macro once the file is opened (or at least after you click the enable macros button).
I also need help on this: I'm using this code to send an email:
ActiveWorkbook.SendMail Recipients:=Range("A1"), _
Subject:="PVR Data"
End Sub
I would like the display alert message that comes up asking me whether I want to send the email to automatically click on yes. I tried using the application.display alerts = False, but it didn't work....I also tried other applications, but none seem to work either. Any ideas? Thank you in advance.
This message was edited by Devon Hill on 2002-08-13 14:12
This message was edited by Devon Hill on 2002-08-13 14:13
I also need help on this: I'm using this code to send an email:
ActiveWorkbook.SendMail Recipients:=Range("A1"), _
Subject:="PVR Data"
End Sub
I would like the display alert message that comes up asking me whether I want to send the email to automatically click on yes. I tried using the application.display alerts = False, but it didn't work....I also tried other applications, but none seem to work either. Any ideas? Thank you in advance.
This message was edited by Devon Hill on 2002-08-13 14:12
This message was edited by Devon Hill on 2002-08-13 14:13