Is this feasible?

[JIMC5499]

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]

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?

 

[JIMC5499]

I meant in Outlook 2003.

 

[JP]

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.c...unting-voting-responses-in-outlook-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.com/blog/2008/10/html-link-building-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

 

[Sue Mosher [MVP]]

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

 

[JIMC5499]

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