What is the maximum distance I can communicate using a standard RS-232 serial cable?

Practically, it depends on your application and environment.

The RS-232 standard specifies transmitting data up to 50 feet at 9600 bits per second (bps).