Posts by salimthaj

  • "Run-time error'13':Type mismatch"

    Re: "Run-time error'13':Type mismatch"


    When i observed keenly,found something which may be of help.


    One ,mail was missed out in between.


    It had a message FYA.........Pls accept..... and the forwarded original message.


    Is this of any help??

  • "Run-time error'13':Type mismatch"

    Hi,


    Can somebody help me with this.


    I got the code from this forum, but when i run the macro it brings up "Run-time error'13':Type mismatch"


    Can somebody help me fix this.


    Regards,


    Salim


    The Code is :[vba]Public Sub ReadEmails()
    ' remember to include a reference to Outlook library

    Dim olApp As Outlook.Application
    Dim olNamespace As Outlook.NameSpace
    Dim olFolder As Outlook.MAPIFolder
    Dim olMail As Outlook.MailItem
    Dim lngRow As Long

    Set olApp = New Outlook.Application
    Set olNamespace = olApp.GetNamespace("MAPI")

    ' Set olFolder = olNamespace.GetDefaultFolder(olFolderInbox)

    Set olFolder = olNamespace.Folders("Personal Folders")
    Set olFolder = olFolder.Folders("Dave")
    'Set olFolder = olFolder.Folders("Dave")

    lngRow = 1
    For Each olMail In olFolder.Items
    With ActiveSheet
    .Cells(lngRow, 1) = olMail.SenderName
    .Cells(lngRow, 2) = olMail.Subject
    .Cells(lngRow, 3) = olMail.Body
    lngRow = lngRow + 1
    End With

    Next
    Set olMail = Nothing
    Set olFolder = Nothing
    Set olNamespace = Nothing
    Set olApp = Nothing
    End Sub[/vba]

  • Search User Form

    Fuzzy Search in USERFORM


    Is it possible to fuzzy search in a field in a user form.


    For Example.


    If the search field is Name


    And the various names are


    Mario
    Martin
    Marlon.


    When a user enters mar, it should bring all three possible matches is it possible.

  • Search User Form

    Re: Search User Form


    Ya what i want to ask is, Is it possible to search using different strings.


    for example, using text box 1 value once,thee next instance using text box 3 value.

  • Contact Creation

    Re: Contact Creation


    Hi Roy,
    Sorry to bother you again.


    I noticed this just now.


    In the database example,the only search criteria is Name.can we add all the fields as search criterias.


    Can you help me out please,because i have done everything and when i was about to present it to my boss.I just realised this.


    Thanks in Advance.


    Salim

  • Import from Oracle

    Re: Import from Oracle


    Thanks Will,
    Thanks for your time.What i do is go to the oracle site and change the dates in certain rows.What i thought was, instead of changing dates in every row individually.I can downloa the whole data from oracle and upload it in to oracle.


    We also open new orders in oracle. is it possible to do this in excel and upload the data in to oracle.


    Am i Clear!!??

  • Import from Oracle

    Hi Everybody,
    I need a help.I think it is too much this time.But still asking you people whether is it feasible or not?.I need to download a data from oracle to excel,make changes and upload it again.Is it possible.Please Advise.


    Regards,


    Salim.

  • Form PopUp

    Re: Form PopUp


    Sorry Norie i didn't understand that at that time.


    Its working fine Now.


    What i did was i didn't use ".


    Thanks for ur help and concern.


    Sorry if i have bothered u too much.


    Thanks a lot once again.