PC Review


Reply
Thread Tools Rate Thread

ACT 2005 (version 7.0) data exchage?

 
 
=?Utf-8?B?bWF0dDE5Nzg=?=
Guest
Posts: n/a
 
      29th Dec 2005
How do I exchange data between Outlook BCM and ACT 2005 (v7)?
 
Reply With Quote
 
 
 
 
audeyt[MSFT]
Guest
Posts: n/a
 
      3rd Jan 2006
Below is for ACT 6 but I believe it should apply to ACT 7 as well:

To export ACT! data for use in another program:
1. Launch ACT!, opening the database you want to export from.
2. Click the File menu, point to Data Exchange, then click Export. The
Export
Wizard opens.
3. In the File type drop-down list, click Text - Delimited.
4. To the right of the Filename and location box, click the browse button.
The
Save As dialog appears.
5. In the Save as type drop-down list, click either Text - Delimited (*.txt)
or
Text - Delimited (*.csv).
6. Navigate to the folder you want to save the file to, then enter a name
for the
exported file into the File name field. ACT! will create this file for you.
Click
Save.
7. Click Next to advance the Export Wizard.
8. Under What kind of records do you want to export?, enable either Contact
records
only or Group records only. When exporting to a text-delimited file, you can
only
export one record type at a time. If you need to export both, first export
the
contacts to one file, and then export the groups to a second file.
9. (Optional) To specify the export options:
a. Click Options. The Export Options dialog box appears.
b. Under Select field separator, click either Comma or Tab. The default is
Comma.
The application you will be importing the data to determines which field
separator
you should use.
c. Under Do you want to export field names?, enable the Yes, export field
names
check box if required. This option can be useful for mapping fields when you
import
into another application.
d. Click OK to close the Export Options dialog box.
10. Click Next to advance the Export Wizard.
11. Under Which contact or group records do you want to export?, click one
of the
following:
.. Current record exports only the currently displayed record.
.. Current lookup exports all the records in the current lookup.
.. All records exports all records in the database.
12. Click Next to advance the Export Wizard.
13. The final page of the Export Wizard allows you to specify the order of
exported
record fields in the text-delimited file. Modify the field export order or
remove
fields from the export process as you require. Or, if you previously saved a
field
map, click the Load Map button.

Note: To ensure a smooth import process into the destination application, it
is
important that you set up the field order to match the order in the
destination
application. For example, if you will be importing the text-delimited file
into an
Excel spreadsheet, ensure you sequence the fields in the same order that
they
appear in the spreadsheet.
.. To change the order of fields in the list, click the field name in the
list above
which you want to insert the field and then click Insert Field. For example,
if you
want to insert a field above Company, click Company and then click Insert
Field.
When you click Insert Field, a drop-down list appears from which you can
select the
field you want to insert. When you insert the field, the field moved from
its
previous location in the list to the location you specified.
.. To remove a field from the list, click any field in the list and then
click
Remove Field. When you click Remove Field, the field is removed from the
list and
will not be exported. If you remove a field from the list, you can always
add it
back by clicking Insert Field.
.. To replace a field in the list, click the field you want to replace. A
drop-down
arrow appears to the right of the field. In the drop-down list, click the
field
that you want to replace the active field. The field that previously
appeared in
that location is replaced with your selection.
14. (Optional) If you expect to need the field map again, click the Save Map
button. In the Save As dialog box, navigate to the folder you want to save
the map
in, enter a File name for the map, and then click Save. Map files are saved
with a
..map extension.
15. Click Finish to begin the export process.

To import the ACT! data into Business Contact Manager:

Open Outlook 2003-> File-> Import and Export-> Business Contact Manager->
Import a
file-> Next-> choose Comma Separate Values(.csv)-> Next-> Click Browse-> Go
to the
location where you have stored the data (as a text delimited file)-> Select
the
file and click open-> Next-> Select the destination-> Ensure that the
checkbox next
to the file name is checked-> Click Map-> Drag each of the fields to the
relevant
field on the right side-> Click OK-> Click Next and this will start the
importing.



"matt1978" <(E-Mail Removed)> wrote in message
news:7812FA79-C006-4C5C-8B17-(E-Mail Removed)...
> How do I exchange data between Outlook BCM and ACT 2005 (v7)?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why Windows XP media center edition version 2002 was intalled when my Windows disks say version 2005 Gilles Goulet Windows XP General 0 18th Nov 2007 02:51 PM
Events raised when table data changed SQL 2005, VB.NET 2005 =?Utf-8?B?RG9hbiBOZ3V5ZW4=?= Microsoft VB .NET 1 30th May 2007 08:00 AM
Re: can send data to sql 2005, can not read data from sql 2005 with vb Cor Ligthert [MVP] Microsoft VB .NET 1 22nd Dec 2006 07:54 PM
XP MCE version 2005 on box but under my computer version 2002 =?Utf-8?B?R0FEWk9PQ1M=?= Windows XP New Users 4 6th Jul 2005 11:25 AM
How to exchage data with other programs? =?iso-8859-1?Q?J=FCrgen?= Ritzau Microsoft Excel Programming 0 3rd Sep 2003 05:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:56 PM.