[mso] Re: Contact Manager Program Needed

I don't have time to check them all out, but a quick google on something 
like 'sample access address contact database' brings alot of results, and 
I know the UtterAccess code archive has a sample.  I know they're out 
there, I bumped into many in the past and adapted the microsoft sample.  
UtterAccess: http://www.utteraccess.com/, do an advanced search and select 
the code archive
Microsoft: http://office.microsoft.com/en-us/templates/TC010185811033.aspx

Regarding the Outlook compatible part of it, we don't use Outlook, so I 
don't have any experience there, but whatever the import format is, once 
you've got the data in Access, you should be able to build a query that 
matches what Outlook needs.  Hopefully someone will be able to give you 
some direction on that piece of it, but, having done this several years 
ago, I do remember there were many nice samples out there, I just went 
with one that was ready to go with minimal customization at the time.

Like David says about exporting from Outlook to Access, doing the export 
he mentioned should show you what you need to build the import query from 
Access, and what fields it wants.  If the sample database you find has 
different field names, etc., that should be easy to remedy in the query, 
where you can format and modify the data to suit Outlook.   Hope this 
helps.




"Alan Bell" <alanb@xxxxxxx>
Sent by:  mso-bounce@xxxxxxxxxxxxx
04/30/2009 06:43 PM
Please respond to mso

To
<mso@xxxxxxxxxxxxx>
cc

Subject
[mso] Re: Contact Manager Program Needed





This is going to be used for data entry by unsophisticated people so I'd
like to have a UI that clear and not prone to error. A naked Access file
wouldn't work at all. 


> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx 
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of David Grugeon
> Sent: Thursday, April 30, 2009 3:16 PM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Re: Ms access query query
> 
> Hi Alan
> 
> I would export from Outlook to a Microsoft Access file, strip 
> out the data and any columns I did not want, and start from there.
> 
> Best Regards
>  
> David Grugeon
> Grugeon Consulting
> (07) 3263 7786
> 



------------------------------------------------------------
The information transmitted is intended only for the person 
or entity to which it is addressed and may contain 
proprietary, business-confidential and/or privileged material.  
If you are not the intended recipient of this message you are 
hereby notified that any use, review, retransmission, dissemination, 
distribution, reproduction or any action taken in reliance upon 
this message is prohibited. If you received this in error, please 
contact the sender and delete the material from any computer.  

Any views expressed in this message are those of the individual 
sender and may not necessarily reflect the views of the company.  
------------------------------------------------------------


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: