Posts by jonny

    Re: Partial VlookUp


    Dear Will, you use FIND(" ",G1,1), but it not probably contains " ".
    It maybe any long string.


    I want to get all strings that beginnig with a source string.

    I would like to do "Partitional VlookUp".
    What I mean, for example in one table I have following items:
    ON
    NATIONAL
    MICRO


    in other table I have:
    ON SEMICONDUCTOR
    NATIONAL SEMICONDUCTOR
    MICRO SEMICONDUCTOR


    I would like to link between same items (to look part of the word).

    I have some code:

    Code
    With olMail
                        .To = FullDetail
                        .HTMLBody = NameHtml & ", " & .HTMLBody
                        .Attachments.Add SourceFile
                        .Attachments.Add PcnFile
                        .Send
                    End With


    After e-mail is sending I would like to turn ".Send" method OFF (to avoid automatically e-mails sending)


    Is anyway to do it?

    Re: date formula for extracting unique dates


    elfudge35, use following code:



    Good Luck! ;)

    Re: Emails FollowUp Reminder


    If I understood you correctly, you mean to sign manually in a table "status of response", and the e-mail wll be send automatically.


    Do you know if the replied or forwarded email carry with it some code/information (in a one of properties) of a source email, that I may catch.


    Thanks

    I have a lot of customers, I send them requests for approvals & waiting for a response. If after 2~3 days I don't get response, I send this e-mail once more.


    If any way to build some macro in VBA that send automatically reminder, if was no response from a customer?


    To use maybe EntryID , or smth else.


    Thank you.

    I have three tables:
    1. Manufacturers
    2. Suppliers
    3. Linked table of both


    Attached the data model printscreen.


    When I try to insert data to form , I receive following error:
    "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."


    What wrong?

    I have difficulty to build relationship for next issue:


    I have:
    1. list of workers (Key: WorkerName)
    2. list of assemblies (Key: AssyID)
    3. list of tests (Key: TestName)
    -------------------------------------------------
    a. each worker may check zero or more assemblies.
    b. each assembly contains one or more tests.


    I will appreciate your help.

    I have some code:
    When I run it I get error "User-defined type not defined excel vba Outlook.Application".

    Code
    Sub SendEmails()
    
    
        Dim olApp As Outlook.Application
        Dim olMail As MailItem
    
    
       Set olApp = New Outlook.Application


    May you helpme to find the problem.


    Thanks in advance.

    I have two columns:


    COMPANY|DATE CODE|
    ----------------------
    SONY |01-Jan-04
    SHARP |01-Jul-05


    When I try to concatenate the rows, I get following:
    SONY 37987
    SHARP 38534


    How I can get by concatenation:
    SONY 01-Jan-04
    SHARP 01-Jul-05


    Thanks

    I have some table with data.
    I need to filter the data by criteria "inactive" in column B and then to delete all rows that fit criteria condition.


    The code is following:


    I understand that next row must be variable?

    Code
    Range("A2").Select


    May anybody to help.
    Thanks in advance.