Send object macro access 2010 emailing reports

[Erocker187]

My issue stems from this: I run a report that shows the last edited record and I need to email this report to the recipient's email listed in the report. When I run the macro, everything works great, and the recipients email is populated as desired, with the exception that the email address appears like this:
@emailaddress.com#mailto: '@emailaddress.com'
Which requires the user to edit the email address field to remove the #and everything after it in order to send the message. This cannot be the end result, as I intend to disable the edit feature and have the email report sent automatically as the record is saved.

Any suggestions?

 

[pbaldy]

It sounds like you may be using a hyperlink field? I just use text for email/web addresses.

 

[Erocker187]

Thanks, i will try that and let you know how it works. I am using hyperlinks.