Act to Access

[Carol Creamer]

Our Customer Service reps are currently using ACT 6.0 to
manage their customer contacts. They always have
problems when they try to merge to a Word document or
merge an email.
We are considering transferring all 8000 records from ACT
to Access 2002 or Access 2003. They need to merge the
customer records to a Word letter, to labels and to
email. Will Access handle all of this and is there any
problem that I need to know about when transferring the
data.
Can I transfer ACT data directly into Access?

Thank you.
Carol Creamer
(e-mail address removed)

 

[Albert D. Kallal]

The word merge problem would be least of your problems. Those contact
managers have a ton of customer tracking stuff that would take you as a
developer a long time to re-produce.

I suspect that creating word templates, and mailing labels works quite well.
Of course, the email stuff is likely where they have he most problems, and I
would say that creating a good emailing system could be some work.

However, ms-access is most certainly capable of doing this kind of stuff.

If you are looking for a rock solid mail merge to word, then I have just the
ticket. Try download my word merge sample, and give it a try. The source
code is included, and thus you can integrate my neat-o template system into
your application that you write.

At least give my example a try to get a taste of how good ms-access is at
doing a word merge.

Check out:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

 

[Arvin Meyer]

ACT is a nasty flat file database, but it does do excellent contact
management. I have successfully converted ACT 6.0 databases to Access 2002
and 2003 and even mapped most of the fields to an Outlook 2003 (Exchange
2003) public folder. As Albert mentioned, it is a lot of work to duplicate
it's functionality. But once it's done you can do so much more with
MS-Office.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Carol Creamer]

Thank you very much. I will give it a try.

Carol

 

[Carol Creamer]

Thank you very much for your reply.

Carol

-----Original Message-----
ACT is a nasty flat file database, but it does do excellent contact
management. I have successfully converted ACT 6.0 databases to Access 2002
and 2003 and even mapped most of the fields to an Outlook 2003 (Exchange
2003) public folder. As Albert mentioned, it is a lot of work to duplicate
it's functionality. But once it's done you can do so much more with
MS-Office.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/2003


.