If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing Outlook Inbox to access (email address)
I have successfully imported my outlook inbox to accesss unfortunately
the email field only shows the name of the individual that emailed and not their full address, for example Joe Smith says "Smith, J" rather than . Is there a way to import the full email address? Thanks, JI |
#2
|
|||
|
|||
Importing Outlook Inbox to access (email address)
Why did you import and not open the data file?
Are your addresses (Contacts) not contained in your origonal data file? and if they were, they would be accessible if you opened the old data file. wrote in message ... I have successfully imported my outlook inbox to accesss unfortunately the email field only shows the name of the individual that emailed and not their full address, for example Joe Smith says "Smith, J" rather than . Is there a way to import the full email address? Thanks, JI |
#3
|
|||
|
|||
Importing Outlook Inbox to access (email address)
On Sep 22, 1:59*pm, "DL" address@invalid wrote:
Why did you import and not open the data file? Are your addresses (Contacts) not contained in your origonal data file? and if they were, they would be accessible if you opened the old data file. wrote in message ... I have successfully imported my outlook inbox to accesss unfortunately the email field only shows the name of the individual that emailed and not their full address, for example Joe Smith says "Smith, J" rather than . *Is there a way to import the full email address? Thanks, JI- Hide quoted text - - Show quoted text - Let me try to explain differently. I have an outlook inbox that I need to run reports off of, (ie how many distinct people emailed us this month?, What domain were they from?, etc.) I am able to take the outlook inbox and import to access for reporting/querying purposes which its great b/c it makes the process fairly automated. The only problem, as stated above is, I can not get the full email address w/ domain name to import into my table. Is there a way to achieve this? Thanks |
#4
|
|||
|
|||
Importing Outlook Inbox to access (email address)
wrote in message
... Let me try to explain differently. I have an outlook inbox that I need to run reports off of, (ie how many distinct people emailed us this month?, What domain were they from?, etc.) I am able to take the outlook inbox and import to access for reporting/querying purposes which its great b/c it makes the process fairly automated. The only problem, as stated above is, I can not get the full email address w/ domain name to import into my table. Is there a way to achieve this? Do you actually have to do an import? Does Access allow you to use a pst file as a direct Data Source? |
#5
|
|||
|
|||
Importing Outlook Inbox to access (email address)
Gordon, Access does indeed allow you to use Outlook folders directly, but
it's not a very useful technique, because it lacks the ability to show even all the reasonably important fields. While articles have been written on how to expand on this method's obvious features, I've never been able to duplicate the results. See http://www.outlookcode.com/article.aspx?ID=25 . Jon, that page will also give you other ideas on how to work with databases and Outlook together. In general, you'll need to write code or use a third-party tool that does the heavy lifting. Importing and linking just aren't good enough. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Gordon" wrote: wrote in message ... Let me try to explain differently. I have an outlook inbox that I need to run reports off of, (ie how many distinct people emailed us this month?, What domain were they from?, etc.) I am able to take the outlook inbox and import to access for reporting/querying purposes which its great b/c it makes the process fairly automated. The only problem, as stated above is, I can not get the full email address w/ domain name to import into my table. Is there a way to achieve this? Do you actually have to do an import? Does Access allow you to use a pst file as a direct Data Source? |
#6
|
|||
|
|||
Importing Outlook Inbox to access (email address)
"Sue Mosher [MVP-Outlook]" wrote in message
... Gordon, Access does indeed allow you to use Outlook folders directly, but it's not a very useful technique, because it lacks the ability to show even all the reasonably important fields. While articles have been written on how to expand on this method's obvious features, I've never been able to duplicate the results. See http://www.outlookcode.com/article.aspx?ID=25 . Thanks for the info! |
Thread Tools | |
Display Modes | |
|
|