Archer/Bard is not my primary... but I can tell you with great certainty that macros will hurt, not help you. Your DPS and overall effectiveness will drop when relying the macros which are not as fast as direct key input for queued action ability.

The only macro (for bard) I have is a buff macro to keep my buffs up as much as possible.
All other actions are lined up for rapid use by single key presses.