TUG News & Updates: General

TUG Tip of the Week - June 14, 2017

Wednesday, June 14, 2017   (0 Comments)
Posted by: Mary Jo Hamik, Beckenhauer Construction, inc.
Share |


Sage 300 CRE Tip: 

Searching SAGE 300 CRE Address Book

Have you ever tried to look for an entry in your SAGE Address Book and only remember part of the name you are looking for”?

SAGE Address Book only searches by the first word of the Company or Person name. My tip for workable solution is to use ODBC and pull information from Address Book into Excel. This allows a user to search key words, locations, and phone numbers as well as other functionality in Excel. Using ODBC is a skill that I learned at a TUG Annual Conference several years ago and use daily. Here is a snapshot of the Microsoft Query and the results in Excel that can be filtered & searched using Excel functions.

Have a comment or question?  Post it below.

Have a tip to share?  Submit a tip here

About Us Membership Knowledge Exchange Events Resources
About Join Now Advocate to Sage Community Calendar Get Connected ⇓
Leadership ⇓ What Members Say User Communities Regional Workshop Affiliate Members
TUG Board of Directors Member Orientation Committees National Conference Associate Members
TUG Past Presidents Get Involved Advertise with TUG
TUGweb Tutorials
TUG Staff Follow Us on Social Media

Contact Us Get Rewarded

Career Center

3525 Piedmont Rd Building 5, Suite 300 Atlanta, GA 30305 Phone: (866) 846-0999

Email: info@TUGweb.com

Connect with TUG