Word & Outlook

Is there anyway of extracting lines out of an email in Outlook, and importing them into the relevant boxes in a Word doc (which has already been created as a form)?
e.g:

The Email looks a little like:

Learning Grant Application Form

Your company name: LEARN.org.uk ltd
Your name: Zaheer Laher
Your position in the company: Company Secretary - Chair

The Word doc looks a little like:

Company Name: box1
Client: box2
Job Title: box3


Could this Word doc be set up as a template like when you do a mail merge?? If so how??

The problem with a mailmerge is that you need a datasource. How are you specifing the emails to merge?

If you search by my username and Outlook you will find allot of code examples on programming against Outlook. ;)

I've created this VBScript file which scans a chosen Mailbox and folder for messages addressed to me. It could be easily pasted into VBA should you require. The settings are specified in the .ini which must have the same name as the application and exist in the same folder.

You can use the code here to open an email (just take out the .Display if you want it to be hidden from the user) and then you can read from the email by setting .body to a string.

Hope this helps,

sugarflux

*Please rate my post if i have helped you!*

Reading the email is not the problem. The problem is the they want to use it as a datasource for a Word Mailmerge.

OK. njwilli didn't mention that s/he wanted to specifically perform a mail merge - just that s/he wanted to pull lines out of an email and push them into a Microsoft Word form.

The way i would do this is search for the relevent email, read the email in line by line and push the required data in to the relevant form fields.

s

Ya, thats the problem. To search in Outlook from Word would bring up the Security prompt. Not to mention that it will be slow
if it involves allot of emails. :( You might have better performance using DAO or ADO to retrieve a recordset of emails and that
could be used as the DataSource for a mailmerge in Word. :D