Emailing a report in Access

L

lsgKelly

I am using the following code to email a report in Access:

DoCmd.SendObject acSendReport, ("rstatusreportfinal1"), acFormatPDF,
[eemail], , , , , True

It works great, until it puts the email address in the To: line. For some
reason, it looks like this:

(e-mail address removed)#mailto:[email protected]#

Unfortunately, this does not work well. I just want the first part of the
email address to show up.

What am I doing wrong? It's driving me crazy!

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2002 change report header text 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Individual Report to each Staff member 0
Save Report to PDF with a Custom Filename & Email.. 0
report in a loop 4
Emailing a report in Excel format 0
Dynamically Name the report attached to email? 1
email Access report pop up network error 1

Top