Jobs at small Albuquerque companies nobody posts about - any advice?

A friend who works at a local manufacturer says there are openings not advertised online. I would rather hear the honest version than the polite one. They prefer people who can start within a couple of weeks. What do you write in a cold email?

A short email with two sentences about what you can do and your résumé attached worked for me. I followed up after a week.