Emailing Reports!

[Priya]

Hi,

I have an email button - on clicking of which I would like
to open our default email client - MS Outlook with a
report attached as a word document

Im using DoCmd.SendObject .... Right now I can get this
working if I have the email address specified in the code.

Problems Im facing:

1. I want to use the " to: email address " from what a
textbox (Email address) on the same form. How can I do
this?

2. The report I'd created has 2 jpegs , but when it
attaches as a word doc, both these jpegs are missing!!
Moreover the format is not the same! Is there a way to get
the word doc to look exactly like my report?

Thanks in advance for any ideas/input

 

[SA]

Priya:

1.) When a report is exported to RTF, all visual graphics, lines, jpegs,
etc. are dropped from the report. The only way to retain those is to output
the report to either a Snapshot format file (which Access can do if you
specify the snapshot format); but this requires your recipient to have a
snapshot viewer installed.

Alternately you can output the report to a PDF file which will retain all
the graphic elements as well; you just need a PDF printer driver such as
Adobe Acrobat, Win2PDF, PDF995 etc. to create the file. Unfortunately since
this is a non-native Access format, you can't use the SendObject command to
attach this file to a mail item. You'd have to do it manually or use a third
party tool like our PDF and Mail Library for Access.

2.) Since you have the To: address on a form, and I assume that you are
calling SendObject from the form, then in the SendObject command, there is a
paramter to specify To:; in that paramter all you have to do is reference
the control on your form as in Me!txtEmail. (If you are using a Macro
rather than Visual Basic for this, then you'd specify

[Forms]![NameOfYourForm]![txtEmailControlName] in the macro's To option.