Hi all
Im copying details from an Outlook contact address book into an Access
database. Originally I was only copying about 10 fields across, using
the the following method, with a line of code for each piece of data
being copied
TempContactRST. AddNew
TempContactRST! FirstName = c.FirstName
TempContactRST! LastName = c.LastName
.........
I've decided that in the future, more info stored in outlook might be
needed to be copied to the access database, so I want to be able to
copy EVERY field across. Is there a quick and efficient way of doing
this, or am I going to have to use the method I'm already using, but
with a line of code for every piece of data that the outlook address
book can hold?
Hope I've made myself clear
Thanks
Charlie
2  5129 
if you want to just use the data from the Contacts table in Outlook,
just link to it. File, Get External Data, Link, switch type to
Outlook, select Contacts. then you can query it as if it were a native
table.
Thanks for your reply
The idea of the module in the database is to transfer contact
information bothways between outlook and access, depending on which is
needed. Eventually the database will be put on quite a few computers,
and one of the aims is to do this with as minimum overhead as possible;
preferebly not having to do what you've suggested on each computer that
will run a copy of the database. If I link the database to outlook and
save it, when I run the database on another pc, will it remember these
settings and link automatically to the copy of outlook on that pc?
Cheers
Charlie pi********@hotm ail.com wrote:
if you want to just use the data from the Contacts table in Outlook,
just link to it. File, Get External Data, Link, switch type to
Outlook, select Contacts. then you can query it as if it were a native
table.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Kurt |
last post by:
Hi
We are developing an off-the-shelf software suite for a certain business sector. Most of the program is simply a GUI on top of some .mdb files. Its a .net application written in c#
One major requirement is "Outlook Integration". The Outlook contact folders are to be used for contact management
I want to know what is the standard way to do this these days. Most of the information in MSDN seems rather old
I first used the Outlook...
|
by: Ronnie |
last post by:
I am faced with quite a conundrum. I have been assigned to develop a
contact database, that can be queried using many different criterion.
Now the hardest part is, my clients want to view the contact
information including their e-mails and eventually send them e-mails.
Now the output could be a group of 50 people that matched the
criterion, and my client wants to be able to e-mail to all of them,
preferably with a single click, just like...
|
by: sfriedman |
last post by:
I was able to successfully link my Outlook Contacts table to an Access
Database and create an entry form. Unfortunately the Displayname field
which is one of the key fields for how the contact is stored states
that it is an expression and will not accept entry, nor will it
automatically conjoin the first and last names as it would normally do
if you entered it in an outlook form. Without this when you click on
the entry in outlook instead...
|
by: lauren quantrell |
last post by:
Is there a way to open the MS Outlook address book using VBA and then
be able to do something with the return value?
I want users to click an icon to open the Outlook address book then
when an address is selected, populate an Access field with the address.
Is this remotely possible?
Thanks,
lq
|
by: charliej2001 |
last post by:
Hi all
My access database has import/export capabiltiy of contact details
between outlook. The database is getting big now (1000+ contacts) and
so are the outlook address books that have the contacts info in them.
When I export contacts from access to outlook, it takes a long time
because there are so many contacts in the Outlook address book, and it
is checking all of these against the contacts coming in, so as to avoid
duplicates....
| | |
by: Phil Stanton |
last post by:
I have a Yacht Club Db with names addresse phone nos, emails etc.
I want to export them to Outlook. No problem in getting them into the
contact folder.
My problem is I have a folder within the contact folder called "Yacht Club"
How do I change the "active folder" from Contacts to "Yacht Club"
Existing code here:
|
by: LeoK |
last post by:
Hello everyone, currently I am building a database for a club in my school. I am at the point where I want to integrate Access with Outlook, this part of the development process has been giving me a lot of problems. I am novice user of Access. I want to basically add all of the emails from a field called EMAIL_ADDRESS from a tabled called MEMBERS to outlooks Contacts list. I also want the contact list to be dynamic meaning if a member is...
|
by: Bill Davy |
last post by:
I am trying to edit Contacts in Outlook. This is so I can transfer numbers
from my address book which is an Excel spreadsheet to my mobile phone. I
came across the following snippet of code which enabled me to the contacts
at least list. I had to root around to discover CdoDefaultFolderContacts
(though it was guessable; how could I enumerate win32com.client.constants?).
I now want to work through the Contacts in Outlook patching in...
|
by: Kevin |
last post by:
In my business, I use Quickbooks extensively for billing and accounting and
a custom built Access DB for project management. I recently began using MS
Outlooks contacts quite extensively as well (recently bought a PDA to bring
to job sites!). I have been able to get things set up so that I can
synchronize my Quickbooks customer and vendor lists with the Outlook
contacts, and thus with my PDA and this has been immensely helpful.
My DB has...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
