E-mailing Report

L

LOU

How do I do it?

We use lotus notes as an e-mail service.

I would like to click a button that send the report to an attached e-mail
were the user selects a person to mail it to.

Any help would be great.

Thank you.
Lou
 
S

strive4peace

Hi Lou,

You can use SendObject, which will use your default eMail program

'========================================= Email
'SendObject
'[objecttype]
'[, objectname]
'[, outputformat]
'[, to]
'[, cc]
'[, bcc]
'[, subject]
'[, messagetext]
'[, editmessage]
'[, templatefile]

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
S

strive4peace

Hi Lou,

"should this be in a Macro assigned to a button?"

actually, what I gave you was VBA code ... if you would like some
information to understand this better, please email me and put "Access
Basics, VBA" in the subject line -- I will email you a 30-page Word doc
on Access Basics and the first 3 chapters of a book I am writing on VBA

"what should the Template be?"

I never use that argument; any argument in brackets is optional

the beauty of using SendObject is that, if LotusNotes is the default
email program, that is what will be used...

if you do not want to go the VBA route (more powerful and flexible than
a macro), SendObject IS a macro action... make a new macro and choose
it, then fill in the parameters.

If your parameters will vary, then use VBA code -- it is not hard once
you know the logic that you need and we are here to help you

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*


Crystal Thank you,

I am a little green at this point of the operation, should this be in a
Macro assigned to a button?

Also, what should the Template be? Do I need to create this in a specific
format and area? My apologies for my Noobieness!~

strive4peace said:
Hi Lou,

You can use SendObject, which will use your default eMail program

'========================================= Email
'SendObject
'[objecttype]
'[, objectname]
'[, outputformat]
'[, to]
'[, cc]
'[, bcc]
'[, subject]
'[, messagetext]
'[, editmessage]
'[, templatefile]

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*


How do I do it?

We use lotus notes as an e-mail service.

I would like to click a button that send the report to an attached e-mail
were the user selects a person to mail it to.

Any help would be great.

Thank you.
Lou
 

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

Top