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
Cannot import send/receive dates for emails stored in Access (.mdb) file
3 posts
• Page 1 of 1
- lisp
- VISIO
- FrontPage
- MS SQL SERVER
- WINDOWS VISTA
- Windows
- MS OFFICE OUTLOOK
- Small Business Accounting
- dreamweaver
- MS OFFICE OUTLOOK
Jump to:
- 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.
Next
Cannot import send/receive dates for emails stored in Access (.mdb) file
by JohnSoPA » Tue, 06 Dec 2005 21:11:05 GMT
Re: Cannot import send/receive dates for emails stored in Access (.mdb) file
by 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
by 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
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 41 guest