By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,984 Members | 2,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,984 IT Pros & Developers. It's quick & easy.

How to implement automatic procedures in MS Access to fill in MS Word document?

P: n/a
MLH
I have tblFiles with [FileID] and [FileName] fields.
DLookUp("[FileName]","tblFiles","[FileID]=22")
returns "c:\EMLfiles\00002.eml".

The return string is a pointer to a dot-eml file in
c:\EMLfiles. The dot-eml file was created in MS
Outlook Express through its File - Save As facility.
Each dot-eml file contains a small paragraph of
text and a small (8k - 22k) graphic file. I'm seeking
mechanism to read and interpret the dot-eml file
and paste it into an open MS Word document.

I really don't know where to begin. I know it is
not as simple as opening the MIME format dot-
eml file with MS Word. I do know that much.
And, I also know that using Edit - Select All from
inside MS Outlook Express, attempting to Copy 'n
Paste the contents of an eMail message (including
the embedded photograph) into an MS Word doc
does not work as desired.

In short, I'm expecting complexities and am hoping
someone here has dealt with similar issue successfully
already.
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
MLH <CR**@NorthState.net> wrote in message news:<4k********************************@4ax.com>. ..
I have tblFiles with [FileID] and [FileName] fields.
DLookUp("[FileName]","tblFiles","[FileID]=22")
returns "c:\EMLfiles\00002.eml".

The return string is a pointer to a dot-eml file in
c:\EMLfiles. The dot-eml file was created in MS
Outlook Express through its File - Save As facility.
Each dot-eml file contains a small paragraph of
text and a small (8k - 22k) graphic file. I'm seeking
mechanism to read and interpret the dot-eml file
and paste it into an open MS Word document.

I really don't know where to begin. I know it is
not as simple as opening the MIME format dot-
eml file with MS Word. I do know that much.
And, I also know that using Edit - Select All from
inside MS Outlook Express, attempting to Copy 'n
Paste the contents of an eMail message (including
the embedded photograph) into an MS Word doc
does not work as desired.

In short, I'm expecting complexities and am hoping
someone here has dealt with similar issue successfully
already.

You _might_ be able to do this by automating Outlook (not OE, I don't
think). The problem AFAIK is that OE does not support automation
whereas Outlook does. If I were you, I'd ask this in the Outlook
programming NG or _judiciously_ crosspost. (Please don't spam 50 NG's
in search of an answer... two or three well-chosen NG's should do the
trick. If you add another message with the same content, it just gets
harder to trace (for you) and folks that d/l their NG content have to
d/l your message twice... not fun.)
Nov 13 '05 #2

P: n/a
MLH,
Ok, I took my Dad's advice and tried it the simple & cheap way. Word opened
an html e-mail I got saying I'd won something on e-bay. The file extenstion
was .eml like you said. So, the brain dead way to do this is save them to a
location and have Word open them for you. As for coding it, if you can't
automate Outlook express so it dumps all the messages then have a clerk do
that. After that you can create your instance of Word in code and have it
do whatever heavy lifting you need to get it into a Word doc.
In short, I'm expecting complexities and am hoping
someone here has dealt with similar issue successfully
already.

Nov 13 '05 #3

P: n/a
MLH
When I use Word 97 SR2 to open a dot-eml file, the attached graphic is
shown as a bunch of characters. Only the binary graphic is a problem.
The body text of the email imported fine, but the graphic is not
displayed as an image.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Sun, 17 Oct 2004 13:32:27 -0400, "Alan Webb" <kn*****@hotmail.com>
wrote:
MLH,
Ok, I took my Dad's advice and tried it the simple & cheap way. Word opened
an html e-mail I got saying I'd won something on e-bay. The file extenstion
was .eml like you said. So, the brain dead way to do this is save them to a
location and have Word open them for you. As for coding it, if you can't
automate Outlook express so it dumps all the messages then have a clerk do
that. After that you can create your instance of Word in code and have it
do whatever heavy lifting you need to get it into a Word doc.
In short, I'm expecting complexities and am hoping
someone here has dealt with similar issue successfully
already.


Nov 13 '05 #4

P: n/a
MLH,
Make sure the HTML editing tools are installed in Office 97. I tried it
using Word 2002. I'll try again on my Office 97 later tonight and see what
happens.
"MLH" <CR**@NorthState.net> wrote in message
news:10********************************@4ax.com...
When I use Word 97 SR2 to open a dot-eml file, the attached graphic is
shown as a bunch of characters. Only the binary graphic is a problem.
The body text of the email imported fine, but the graphic is not
displayed as an image.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Sun, 17 Oct 2004 13:32:27 -0400, "Alan Webb" <kn*****@hotmail.com>
wrote:
MLH,
Ok, I took my Dad's advice and tried it the simple & cheap way. Word
opened
an html e-mail I got saying I'd won something on e-bay. The file
extenstion
was .eml like you said. So, the brain dead way to do this is save them to
a
location and have Word open them for you. As for coding it, if you can't
automate Outlook express so it dumps all the messages then have a clerk do
that. After that you can create your instance of Word in code and have it
do whatever heavy lifting you need to get it into a Word doc.
In short, I'm expecting complexities and am hoping
someone here has dealt with similar issue successfully
already.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.