Emailing from Access

P

Parker

Hi,
I want to email my bills to my customers using Access. Could someone
provide me with some links so I can learn how to do this?
I am running Office XP on Windows XP sp2. Thank-you.
 
A

Al Campagna

Parker,
Use the SendObject method (see Help). The arguments in the method are all self
explanatory.
Post back if you need more specific help...

Also, just try a Google on "microsoft access" "sendobject"... I'm sure you'll find many
articles on the use of SendObject.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
T

Tony Toews [MVP]

Parker said:
I want to email my bills to my customers using Access. Could someone
provide me with some links so I can learn how to do this?
Click to expand...

You'll need to work a bit in VBA code which can be a bit tricky for
someone not used to it.

1) Do you want to send the bill as a PDF file or in the body of your
email? I'd suggest PDF files as the customers can then print them and
they will have your logo, etc on them.

A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required.
http://www.lebans.com/reporttopdf.htm

2) For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.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
 
P

Parker

Thanks Tony.
Tony Toews said:
You'll need to work a bit in VBA code which can be a bit tricky for
someone not used to it.

1) Do you want to send the bill as a PDF file or in the body of your
email? I'd suggest PDF files as the customers can then print them and
they will have your logo, etc on them.

A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required.
http://www.lebans.com/reporttopdf.htm

2) For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.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
Click to expand...
 
A

Aaron Kempf

emailing from the desktop is a security risk

using Access Data Projects; you can easily email from the SERVER

xp_sendmail


all this VBA crap is too much work for the effort

MS crippled outlook 10 years ago
 
Top