Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2007

Tip: Looking for answers? Try searching our database.

merge from Outlook to word 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Herb Segal - 05 Dec 2007 22:26 GMT
Can anyone tell me how I can merge an email into microsoft word 2003?

I have a form on our office website that when the user submits it comes in
via email and has 20+  fields of information. I'd like to paste the fields
automatically into an application for insurance.

Does it have to go to an access database or excel spreadsheet first? The
email goes to a public folder in exchange and I didn't see the public
folders when I tried to export.
Graham Mayor - 06 Dec 2007 07:35 GMT
See http://gregmaxey.mvps.org/Extract_Form_Data.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Can anyone tell me how I can merge an email into microsoft word 2003?
>
[quoted text clipped - 5 lines]
> The email goes to a public folder in exchange and I didn't see the
> public folders when I tried to export.
Herb Segal - 06 Dec 2007 14:50 GMT
Thanks so much. I'll give it a try.

> See http://gregmaxey.mvps.org/Extract_Form_Data.htm
>
[quoted text clipped - 7 lines]
>> The email goes to a public folder in exchange and I didn't see the
>> public folders when I tried to export.
Peter Jamieson - 06 Dec 2007 07:41 GMT
There is no out-of-the-box feature in Word designed to deal with this, but I
wonder what facilities already exist to extract data from these incoming
messages? EIther someone designed and implemented a complete system that
creates the forms, puts them on the web server, collects them in a public
folder and then does something with them, or you happen to have the first
part of that system but not the last. (NB, there are facilities in Access
and Outlook 2007 designed to do data collection via e-mail - I have no idea
what they are like or whether you are in a position to use them, but it may
be worth looking).

If there are no such facilities, you would need to know more about the
format of these e-mails and write some code (e.g. perhaps using Word VBA and
the Outlook object model) that can extract the data and stuff it directly
into a Word document. And no, I don't get to see my Public Folders in the
Export dialog box in Outlook either.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Can anyone tell me how I can merge an email into microsoft word 2003?
>
[quoted text clipped - 5 lines]
> email goes to a public folder in exchange and I didn't see the public
> folders when I tried to export.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.