Access 2007

[pleasehelpme]

I am using a program written in 2003 Office, I am using Office 2007, and need
to eamil invoices to customers from 2007. Can someone tell me how to do this
in 2007. Seems 2003 was much easier.
Thank you

 

[a a r o n . k e m p f]

I do this via XP_SendMail and there are lots and lots of parameters to
this stored procedure.

and for me-- this syntax didn't change between Access 2003 and 2007.

Of course-- I use the most popular way to store your data-- SQL
Server-- but I still use Access for forms and reports.

It's this thing called 'Access Data Projects' and its' just really a
question of whether you want to centralize your business logic in a
logical manner-- or keep mountains and mountains of bad vba code

-Aaron

 

[Tony Toews [MVP]]

I am using a program written in 2003 Office, I am using Office 2007, and need
to eamil invoices to customers from 2007. Can someone tell me how to do this
in 2007. Seems 2003 was much easier.

You can use the same method in Office 2007 that you used in Office
2003. How were you doing it then?

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

I am using a program written in 2003 Office, I am using Office 2007, and need
to eamil invoices to customers from 2007. Can someone tell me how to do this
in 2007. Seems 2003 was much easier.

Please ignore Aaron Kempf's posting as it is irrelevant to your
requirements.

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/

 

[a a r o n . k e m p f]

Tony;

It's perfectly relevent--
Emailing from desktops is a security risk. Only through
centralization and stored procedures can you make this manageable,
reliable, automated and secure.

-Aaron