send an email automatically

[chris23892 via AccessMonster.com]

ok, need some direction here. Not sure where this thread needs to be.

Background:

I have a database that I enter data for warranty. I have a feild in my main
page where I enter data for a RMA number. Now, when I'm entering data, I
don't have a RMA number, so I just put in the letteres RMA.

I may do up to 20 units per sitting, so I have a button that I just click and
every record that has RMA in the RMA feild gets exported to Excel in a nice,
neat preformatted way. This works AWESOME. I want to take this to the next
step.

What I want to do is have access send this excel sheet out in an email. Right
now, I have to do this by hand. I have to save the exported sheet, then goto
Outlook, compose the same email I've composed a million times, and insert
this sheet.

There has to be a way to make this happen when I press my export button in my
main page in access. The name are always the same in the email and the body
of the email is always the same.

Any suggestions on where to start?
Thanks!!

 

[Dale Fye]

Take a look at the "SendObject" method in help.

 

[Tony Toews [MVP]]

I may do up to 20 units per sitting, so I have a button that I just click and
every record that has RMA in the RMA feild gets exported to Excel in a nice,
neat preformatted way. This works AWESOME. I want to take this to the next
step.

What I want to do is have access send this excel sheet out in an email. Right
now, I have to do this by hand. I have to save the exported sheet, then goto
Outlook, compose the same email I've composed a million times, and insert
this sheet.

There has to be a way to make this happen when I press my export button in my
main page in access. The name are always the same in the email and the body
of the email is always the same.

Yes, you can do this but you'll have to customize lots of VBA code.
There are two steps to this.

1) Create the spreadsheet in Excel.

Some code to get you started can be found at
http://www.mvps.org/access/modules/mdl0035.htm. You will probably
want to give the Excel file a unique name. Possibly by date or simply
an ascending number. Such as "Joe Blow RMA # 123.xls."

2) Send the above file via outlook.

See the Outlook specific links at the Access Email FAQ at my website.
http://www.granite.ab.ca/access/email/outlook.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/