Mike, I can't verify this with Access due a problem with ODBC drivers on my
machine, but if I export to CSV, there's a field called "Body" that has the
full text. Don't you see this in an access table? If not, I'd suggest you
export as CSV and then import into access.
Joe
> -----Original Message-----
> I subscribe to several listservs and get many useful Windows
> and Office tips.
> I'd like to save this useful info from the Outlook inbox to a table in
> Access. Trying Outlook's export works, but somehow drops the
> actual text of
> the msg, only exporting the header info. i.e. I select export, save as
> Access, select which folder, and go.
> Open Access and find on only the Date, From, To, Subject, and
> some misc
> fields are in the table. Not the text part.
> Since I'm not given a choice of what to export, I'm at a loss
> as to how to do
> it. Thoughts?
> Mike Hayes
PCSOFT maintains many useful files for download
visit our download web page at:
http://nospin.com/pc/files.html
|