Macro for importing email body data (comma separated string) into custom contact form in outlook

Posted on 2009-02-09
Last Modified: 2013-12-25
I receive by emaithe data inserted by applicants on my webpage, the email body received for each application has a comma | separated string. I need to map this string to specific fields on a custom contact form.


{Name:value}|{Email:value}|{Phone:value}|{Address:value}|{Skype:value}|{CAT Tools:value}|{Expertise:value}|{Expertise 2:value}|{Expertise 3:value}|{Expertise 4:value}|{Native Language:value}|{Source 2:value}|{Source 3:value}|{Target:value}|{Target 2:value}|{Target 3:value}|{translation price:value}|{Interpreter price:value}|{Transcription price:value}|{Education:value}|{Past work:value}|{Associations:value}|

I have some small knowledge of VB, not much, but I know this should not be difficult..

Thanks in advance
Question by:linktranslation
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    This needs to be done in two steps.

    1. Open the Outlook email and extract the body text (Via code or manually)
    (If you want this done Via code, it might be better to post this part of the question as a brand new question, as this will require VBA Coding)
    2. Create an Import specification that specifies the Pipe ( | ) symbol as the delimiter, thne perform the import via code.

    What version of Access please.


    Author Comment

    Hi Jeff,
    Thanks for your quick response.

    What I am looking for is a complete script such as provided by another colleague from e- at, but this one he import contact information from an excel  file to the custom contact form

    The difference is that I want to read information (text with | delimiter)  from each email body from a especific folder and import to a CUSTOM contact form.

    could I integrate the below into the solution above somehow?
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    "What I am looking for is a complete script "
    What you have asked for here is a complete "Project", not a simple question requiring a straight forward answer.

    Although some Experts will provide "Complete solutions", many may not because they view a request for a full solution as an attempt to solicit "Free Consulting".

    Most will only do so for only the highest points value questions.

    I suggest you try breaking this question into separate questions to generate more interest, and assigning each question a points value that is commensurate with a "Fill Project".




    Accepted Solution

    OK, thanks Jeff
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    If your issue is not resolved then simply request that the question be deleted.

    By "Accepting" you own post, you have closed the question.
    Your post appears as the "Solution" even though there was no solution.

    Please click the "Request Attention button in your original post to have this fixed.




    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now