I would like to embed a macro into an e-mail. What I need is the ability to
assign a number to a string value and then use that string as a file name in
an attachment path and a link to a folder. I also need to be able to put
three buttons into the e-mail. They would be "Approved", "Not Approved" and
"No Action Required". The selection of one of these buttons would send a
canned reply E-mail. Can this be done in Access 2003?

"JIMC5499" wrote:

I would like to embed a macro into an e-mail. What I need is the ability to
assign a number to a string value and then use that string as a file name in
an attachment path and a link to a folder. I also need to be able to put
three buttons into the e-mail. They would be "Approved", "Not Approved" and
"No Action Required". The selection of one of these buttons would send a
canned reply E-mail. Can this be done in Outlook 2003?

I meant in Outlook 2003.

"JIMC5499" wrote:

I would like to embed a macro into an e-mail. What I need is the ability to
assign a number to a string value and then use that string as a file name in
an attachment path and a link to a folder. I also need to be able to put
three buttons into the e-mail. They would be "Approved", "Not Approved" and
"No Action Required". The selection of one of these buttons would send a
canned reply E-mail. Can this be done in Access 2003?

If I understand you correctly, you want your email to contain a link
to a file?

To create the email, you need code like this:

Dim myOlApp As Object
Dim myItem As Object
Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(0)

I assume by "buttons" you mean voting buttons. See
http://www.codeforexcelandoutlook.co...ook-using-vba/
for putting the voting buttons on the email. When they are clicked, a
voting response is sent. I don't believe you can customize the reply
at all (other than seeing the custom voting options you set up when
sending the message).

See http://www.codeforexcelandoutlook.co...g-using-excel/
for sample code that shows you how to format the links in the email
body.

As far as "What I need is the ability to assign a number to a string
value and then use that string as a file name in an attachment path
and a link to a folder." I'm not clear what that means. You can always
append a number to a string, as long as you convert it to a string
first. For example

Dim MyString As String
MyString = "Hello World" & "3"
MsgBox MyString

--JP

On Feb 8, 3:14*pm, JIMC5499
wrote:
I would like to embed a macro into an e-mail. *What I need is the ability to
assign a number to a string value and then use that string as a file name in
an attachment path and a link to a folder. *I also need to be able to put
three buttons into the e-mail. *They would be "Approved", "Not Approved" and
"No Action Required". *The selection of one of these buttons would send a
canned reply E-mail. *Can this be done in Access 2003?

If you mean that you want the message to run some kind of code, no, that's
not possible unless your scenario meets the requirements for using a custom
Outlook message form; see http://www.outlookcode.com/article.aspx?id=61
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"JIMC5499" wrote in message
...
I would like to embed a macro into an e-mail. What I need is the ability
to
assign a number to a string value and then use that string as a file name
in
an attachment path and a link to a folder. I also need to be able to put
three buttons into the e-mail. They would be "Approved", "Not Approved"
and
"No Action Required". The selection of one of these buttons would send a
canned reply E-mail. Can this be done in Access 2003?

It doesn't meet those requirements. Thank you for saving me alot of time.

"Sue Mosher [MVP]" wrote:

If you mean that you want the message to run some kind of code, no, that's
not possible unless your scenario meets the requirements for using a custom
Outlook message form; see http://www.outlookcode.com/article.aspx?id=61
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"JIMC5499" wrote in message
...
I would like to embed a macro into an e-mail. What I need is the ability
to
assign a number to a string value and then use that string as a file name
in
an attachment path and a link to a folder. I also need to be able to put
three buttons into the e-mail. They would be "Approved", "Not Approved"
and
"No Action Required". The selection of one of these buttons would send a
canned reply E-mail. Can this be done in Access 2003?


.