Yes, its working. i just want to know if any Fine tuning can b done. Like i use a function to resolve an emailid, ie;manual entry of emailid Fr each name in that function. Is there another way.
Hi, can u suggest any improvement on the below code.
=======================================================================================
'this function returns email id to respective name. These emailid's are available in the outlook.
Function EmailAdd(nameid) As String
Select...
Hi, I have data in excel.The script has for loop to compare the data inside the excel. what is best way to fetch it from outlook vba. i knew that opening a excel is slower. Snap shot of the excel is attached.
Private WithEvents Items As Outlook.Items
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Item = MailItem
If Item.To = "abc@abc.com" Then
prompt$ = "Are you sure you want to send this message?"
If MsgBox(prompt$, vbYesNo + vbQuestion +...
Re: Change To address when it is sent to a specific address during specfic tim
Thanks for the info.
Yes it should check mail when I send .
below is the screen shot of the excel sample.
The format can be changed. but then how it will fetch the data according.
I think you asked...
Hi, As a new bee. I was wondering how to do in outlook vba:
1.An excel sheet template is available with "FromDate", "ToDate", "Time", "Name" column.
2.When email is sent to a specific Team , it should look the time.
-and if time lies in mentioned range or Time in excel sheet,
-it changes...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.