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

Posted on 2009-02-09
Medium Priority
Last Modified: 2013-12-25
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.


{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
  • 3
  • 2
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 23592183

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

ID: 23592463
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?
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 23596921

"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

linktranslation earned 0 total points
ID: 23605479
OK, thanks Jeff
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 23951120

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.




Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

839 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