Whenever I attempt to send an email through the macro SendEmail, a ' is added on each side of the address, preventing it from being sent. This applies to both regularly typed email addresses and to =[tablelocation.email] emails. Is there a way to remove the ' so I can send the emails?