|Knowledgebase Home | Glossary | Favorites | Contact | Login|
|MS Excel Spreadsheet to ACT! - map Act4Advisors fields to your spreadsheet|
Open ACT. You may do a Lookup then click on Contact List or you can choose your group and click on the Groups button. Minimize ACT (do not close ACT)
Open up MS Excel Spreadsheet. Click on the "ACT!" menu item in Excel. Choose "Map to Contact..." (or the Company or Group option). You'll get a field list just like a Word merge template, except these are all fields from the current contact record, no "my record" stuff here. Create your spreadsheet. See example below.
When you are done, go to File, Save As and give it a name. Close Excel.
Maximize ACT. Click on the Documents tab; click on Add Document and locate your spreadsheet and press Open.
If you'd like it a little more automated, you could have an SDK'er make this process a menu item or toolbar button to do it in one click. (I've written this before and could do it for you very easily.)
|No related articles were found.|
|No attachments were found.|
ACT! is a registered trademark of Sage Software, Inc.:::Allied Financial Software, Inc. Copyright 1999-2009