Cannot import send/receive dates for emails stored in Access (.mdb) file

MS OFFICE OUTLOOK

    Next

  • 1. WIN98 & Outlook 2002
    Windows 98 machines unable to open Outlook 2002!
  • 2. won't remember password
    Just loaded my old Office 2000 on a new computer, an HP with MS Windows XP Home edition. I cannot get the OUlook or Outlook Express to remember my password. I have done the properties - accounts - remember - apply etc, but no good. I am sure there is a simple solution I am just not seeing. Any ideas? CZ
  • 3. Unable to open mailboxes after nightly backup runs
    Hi, I am using Veritas backup exec 9.0 with Exchange 2003. I just started backing up individual mailboxes and since have had the same problem every day after that nightly backup job runs. The following day that clients ie outlook, cannot open their mailboxes. Outlook hangs etc. Yet all services are running on exchange etc. I checked with the veritas checklist and everything is covered there. So I am wondering if anyone has seen this and what they did to fix it? ps- the mailboxes seem to backup correctly..... Confused, Mike
  • 4. delay receiving email
    I have a small Exchange 5.5 environment with about 10 users running Windows XP Pro with Outlook 2002. I had one user inform me that all of a sudden when a new email arrives, it won't appear in the inbox until she clicks on another folder. I tried another test with other users and as soon as you send the email, it appears instantly without the user having to click on other objects. All the other users except this one, receive email without having to click on other objects. Any ideas would greatly be appreciated.

Cannot import send/receive dates for emails stored in Access (.mdb) file

Postby JohnSoPA » Tue, 06 Dec 2005 21:11:05 GMT

I have some mdb (Access format) database files with thousands of emails
extracted from couple of Yahoo groups forums.  I'd like to import these
into my Outlook 2003 PST so that I can search and read them offline.

The mdb files contain all the fields necessary for a proper email
import, including

from_name
from_email
subject
receive_date
receive_time
message (HTML format)

When I use the Outlook "Import and Export Wizard", selecting Access
file type, etc., all appears fine.  However, after the import
completes, in Outlook there is no date information populated under
either sent or received date.

If I use the "map custom fields" button on the import wizard, all of
the import file fields are shown correctly on the left hand "from" side
(as listed above) but on the right hand "to" side I only see the
following Outlook fields to map to:

subject
body
from/to/cc/bcc (name)
from/to/cc/bcc (address)
from/to/cc/bcc (type)
billing information
categories
importance
mileage
sensitivity

For whatever reason, THERE IS NO DATE FIELD to map to.

I can map date to something like "billing information" but that doesn't
help much

I appreciate any help or advice you can provide!

Thanks,

John


Re: Cannot import send/receive dates for emails stored in Access (.mdb) file

Postby JohnSoPA » Sat, 10 Dec 2005 03:45:29 GMT

Could any of the experts here recommend a subgroup that might be able
to answer this?

Thanks,

John


Re: Cannot import send/receive dates for emails stored in Access (.mdb) file

Postby Brian Tillman » Sat, 10 Dec 2005 05:10:01 GMT




Importing doesn't handle date fields, as far as I know.  At best the date 
will be set to the date of the import.
-- 
Brian Tillman 


Similar Threads:

1.Within ACCESS, Send a .mdb file with linked table as email Attachm

Any code suggestions on how to send a small .mdb database containing a linked 
table as an email attachment from within an access application.   I know that 
I can send the linked table as an excel spreadsheet, but I would really like 
to send the linked table's mdb file.  To clarify:  I'm running an access 
application  (app1).  There is a linked table from another small access 
database (data1) containing limited info.  I would like from within the 
access application (app1) to generate an email with the database (data1) 
containing the linked table as the attachment to the email.  The operator 
does not need to be able to edit this in their email editor.  This can 
preferrably go directly to a preset email recipient, and then notify the 
sender that it was sent and or stick it in their "sent box".    I am not a 
good coder at all.. thats why I work in Access..   But I can hack some 
cookie-cutter code together if shown some samples and direction.   Biting off 
a bit more than I can chew and need some help.   Thank you.

2.Within ACCESS, Send a .mdb file with linked table as email Att

I could create the file as a dbf. or other database type if needed. Or rename 
it as .txt, send it, then rename it again back to mdb once received if it is 
possible to make send any other file type from within access.  ... why would 
Outlook block the mdb file type?

"AB" wrote:

> FYI, if you're using Outlook you can't email an Access database. The.mdb
> filetype is blocked.
> 
> "titlepusher" < XXXX@XXXXX.COM > wrote in message
> news: XXXX@XXXXX.COM ...
> > Any code suggestions on how to send a small .mdb database containing a
> linked
> > table as an email attachment from within an access application.   I know
> that
> > I can send the linked table as an excel spreadsheet, but I would really
> like
> > to send the linked table's mdb file.  To clarify:  I'm running an access
> > application  (app1).  There is a linked table from another small access
> > database (data1) containing limited info.  I would like from within the
> > access application (app1) to generate an email with the database (data1)
> > containing the linked table as the attachment to the email.  The operator
> > does not need to be able to edit this in their email editor.  This can
> > preferrably go directly to a preset email recipient, and then notify the
> > sender that it was sent and or stick it in their "sent box".    I am not a
> > good coder at all.. thats why I work in Access..   But I can hack some
> > cookie-cutter code together if shown some samples and direction.   Biting
> off
> > a bit more than I can chew and need some help.   Thank you.
> 
> 
> 

3.How to export e-mail to mdb with time/date sent & received fields

I am tryting to export the content of Outlook mail folders to a Microsoft 
Access .mdb file.  I need each record to contain fields for the time/date 
sent and the time/date received.  Is there a way to accomplish this goal?

4.Cannot share an Access 2003 mdb file

I have created an access mdb file and saved it in a shared folder in a 
server. I had configured the permissions so that many users could access the 
data simultaniously from their desktops. A new administrator changed the 
permissions and now only one user can access the database at a time. When a 
second user tries, he receives a message that the file is already in use. I 
can not find the right combination of permissions and i don't know if there 
is another problem. Any suggestions.  
-- 
cherry

5.Allowing receiving of Access MDB file

I am creating an application that the main operator will press a button in a 
Access program, and it will query certain info., package it in new table, 
e-mail it to a user, he will update the data, send it back, and then the data 
will be updated into the main table.  Although I've haven't worked out all 
the details yet, a big stumbling block is how Outlook 2003 will receive the 
data, as it currently doesn't, unless the mdb file is renamed to *.doc or 
something. (Outlook 2003 will not receive access files - unless someone knows 
away to disable that limitation). But if I do that, it wouldn't be easy for 
the user to open Access automatically.  Any one send and receive data back 
and have to do anything like this?  Your insight would be a blessing. 

Thanks in advance.......

6. sending attachment .mdb files by Access

7. how to send and receive mdb files with microsoft outlook

8. Exporting Date received and Date Sent to Access



Return to MS OFFICE OUTLOOK

 

Who is online

Users browsing this forum: No registered users and 41 guest