• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • Last Modified:

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

I receive by emaithe data inserted by applicants on my webpage http://www.linktranslation.com/~linktran/work-with-us, 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.

Exemple

{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
0
linktranslation
Asked:
linktranslation
  • 3
  • 2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
linktranslation,

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.

JeffCoachman
0
 
linktranslationAuthor Commented:
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 http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_21601092.html#discussion, 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?
http://www.example-code.com/vb/splitComma.asp
0
 
Jeffrey CoachmanMIS LiasonCommented:
linktranslation,

"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".

;-)

JeffCoachman

0
 
linktranslationAuthor Commented:
OK, thanks Jeff
0
 
Jeffrey CoachmanMIS LiasonCommented:
linktranslation,

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.

Thanks

;-)

JeffCoachman
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now