EMAIL SUBJECT

[koja]

Can somebody help me with this problem....?
I have to send an e-mail every day with a microsoft access 97.
Is it possible to configure access to adjust a subject of this email related
to it's daily changing content. The subject should be automatically extracted
from a field in an query.
Thank you!

 

[Douglas J. Steele]

Take a look at what Tony Toews has in the Microsoft Access E-Mail FAQ at
http://www.granite.ab.ca/access/email.htm

 

[Arvin Meyer]

Can somebody help me with this problem....?
I have to send an e-mail every day with a microsoft access 97.
Is it possible to configure access to adjust a subject of this email related
to it's daily changing content. The subject should be automatically extracted
from a field in an query.
Thank you!

First download the code at:

http://www.datastrat.com/Code/MultipleEmail.txt

Then change this line:

.Subject = strSubject

to the query field in the recordset, like:

.Subject = "Invoice for: " & rst!ContactName

or possibly:

.Subject = strSubject & " " & rst!ContactName

if you're using a form variable or code variable.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[PC User]

Is is possible to receive e-mails directly into access?

Thanks,
PC

 

[Arvin Meyer]

No you need a mail client. There are a few apps which will transmit data
from email into Access, but you will need to parse it out to get it in the
right fields. Have a look at MapiLabs, which may have something useful for
you:

http://www.mapilab.com/?mapilabs
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access