By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,933 Members | 1,223 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,933 IT Pros & Developers. It's quick & easy.

SendObject process automation

P: n/a
AJ
I have a student registration database, that prints a report to PDF. I am
using the sendObject method to create an E-mail and write THAT student's
registration to a report for him.

I am trying to automate the process, so it will cycle through each of the
students without user intervention. Right now, it will
1. create the report, 2. create the E-mail (with inserted E-mail address and
message), but I have to

1. Save the PDF report to file
2. Attach it to the E-mail
3. Send. it.

So, my question is, from a SendObject E-mail object, how do I automate the
steps:

A. "Save"
B. Replace? "Yes"
C. Find File
D. Insert file (to SendObject mail object).
E. Send E-mail.

Is there a macro language I can reference and use in VBScript or something?
(I figure for step C I will make a variable that will hardcode a location,
and the file name, and tell it to look at THAT location for a file with THAT
name.

But is there a reference for the script wording fo the rest? Thanks in
advance.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Use the info in the MS KB article "Using Automation to Send a Microsoft
Outlook Message," Article ID: Q161088; at URL:

http://support.microsoft.com/default...b;en-us;161088

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQtKhNoechKqOuFEgEQIeJwCgh7XV4RwVDs2vF3aBpoNPH2 gv8CMAnjj4
J94vz7wSTLUBPhFNikzegd9N
=ITlD
-----END PGP SIGNATURE-----
AJ wrote:
I have a student registration database, that prints a report to PDF. I am
using the sendObject method to create an E-mail and write THAT student's
registration to a report for him.

I am trying to automate the process, so it will cycle through each of the
students without user intervention. Right now, it will
1. create the report, 2. create the E-mail (with inserted E-mail address and
message), but I have to

1. Save the PDF report to file
2. Attach it to the E-mail
3. Send. it.

So, my question is, from a SendObject E-mail object, how do I automate the
steps:

A. "Save"
B. Replace? "Yes"
C. Find File
D. Insert file (to SendObject mail object).
E. Send E-mail.

Is there a macro language I can reference and use in VBScript or something?
(I figure for step C I will make a variable that will hardcode a location,
and the file name, and tell it to look at THAT location for a file with THAT
name.

But is there a reference for the script wording fo the rest? Thanks in
advance.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.