Recent content by densetax2

  1. D

    Geting data from excel to outlook

    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.
  2. D

    Geting data from excel to outlook

    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...
  3. D

    Geting data from excel to outlook

    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.
  4. D

    item send not tigering.

    yes it has been set to "No security".
  5. D

    item send not tigering.

    Tried that as well. but nothing happened. is it i am doing wrong. I created - Thisoutlooksession > insert > module > added the code and saved.
  6. D

    item send not tigering.

    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 +...
  7. D

    Change To address when it is sent to a specific address during specfic time.

    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...
  8. D

    Change To address when it is sent to a specific address during specfic time.

    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...
Back
Top