Outlook from Acces (XP)

[Ima Lostsoul]

I know I had this code somewhere but the library that I stored it in has
long since slipped off of the active list. Anyway can someone point me
to code that will allowing the following.

1) Program User clicks a button on an Access form.

2) Outlook email is generated in background.

3) Email is addressed to Program Users Review User. This relation is
held in the user table in the program.

4) A file is attached to the email. File will be located at the same
place for all users and will have the same name.

5) Mail is sent.

6) All is done in background.

Thanks,
DB

[Tony Toews]

Ima Lostsoul <[e-mail]> wrote:

I know I had this code somewhere but the library that I stored it in has
long since slipped off of the active list. Anyway can someone point me
to code that will allowing the following.

See the Outlook section of the Access Email FAQ.

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

[Ima Lostsoul]

In article <vn********************************@4ax.com>,
tt****@telusplanet.net says...

Ima Lostsoul <[e-mail]> wrote:

I know I had this code somewhere but the library that I stored it in has
long since slipped off of the active list. Anyway can someone point me
to code that will allowing the following.

See the Outlook section of the Access Email FAQ.

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

Where might one find the Access Email FAQ? :)

[Ima Lostsoul]

In article <vn********************************@4ax.com>,
tt****@telusplanet.net says...

Ima Lostsoul <[e-mail]> wrote:

I know I had this code somewhere but the library that I stored it in has
long since slipped off of the active list. Anyway can someone point me
to code that will allowing the following.

See the Outlook section of the Access Email FAQ.

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

Never mind. I am still working on getting up to stupid.

[Tony Toews]

Ima Lostsoul <[e-mail]> wrote:

Never mind. I am still working on getting up to stupid.

<smile> Nope. I should've been more clear on my instructions.

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