yes, you can spray any latex or oil based paint through
the Wagner style sprayer. That is what they were designed for.
Whatever paint you choose, read, understand and follow the
application directions as well as the safety concerns.
If I remember correctly, the Wagner has an adjustment knob for
the viscosity of the product you are spraying. Just play around
with it until it suits your skill level.
Check the good ole YouTube !! MANY good tutorials on how to
paint with the electric paint sprayer. They are basically the same.
Doesn't matter if it is a Wagner or Harbor Freight .
Basically, I would add a little thinner to the paint and practice on
something first, prior to painting the real thing.
Have a paint brush at the ready to address any runs and drips.
you WILL have runs and drips !!! so just use the paint brush to
make it look good. Several light coats will be far more durable than one heavy coat.
When I say add thinner - it is water for latex base and mineral spirits for oil base.
Clean the sprayer as soon as you are done...... the longer paint sits in the nozzle,
the more difficult it is to clean. Apply a little vaseline to moving parts for storage.
For a novice painter, I would not suggest any kind of two-part paints such as epoxy, etc.