Anonymous Email

[longytravel]

Hi Guys.

I have developed a fairly straightforward 'feedback form'

I send the sheet out to people who i have worked with so they can rate my performance it has drop down boxes 0 - 10 etc.

They then press a button and then it emails it back to me.

Is there anyway i can make it return the sheet back to anonymously in outlook - effectively i don't want to know who has provided the feedback

Any ideas??

Thanks

 

[longytravel]

Thanks!

Great out of the box thinking!

It nearly works.....i get a message box asking if i want outlook to send the email - i should select no if it is not from atrusted source.

The process then jsut goes round and round until i cancel it........

I think the process just needs tweaking to make it work if you can have another quick think about it?!!

 

[AD_Taylor]

Thanks!

Great out of the box thinking!

It nearly works.....i get a message box asking if i want outlook to send the email - i should select no if it is not from atrusted source.

The process then jsut goes round and round until i cancel it........

I think the process just needs tweaking to make it work if you can have another quick think about it?!!

Thanks - out of the box thinking is my speciality

As I say it was untested - I'll do some quick testing now and get back to you.

 

[AD_Taylor]

Ok try this:

Sub CustomRule_Forward(feedbackMail As Outlook.MailItem)

Dim strId As String, olNS As Outlook.NameSpace

Dim forwardItem As Outlook.MailItem
strId = feedbackMail.EntryID
Set olNS = Application.GetNamespace("MAPI")
Set forwardItem = olNS.GetItemFromID(strId).Forward

forwardItem.Display
forwardItem.Recipients.Add "dean.allison@stockgrn.bham.sch.uk"
forwardItem.Subject = "New Feedback - Sent By Rule"

forwardItem.Body = ""

forwardItem.Send

End Sub

As long as the subject in the code above is different to the subject sent by your form you shouln't get a problem.

 

[longytravel]

Top stuff!!

That works like a dream!!

Its all about thinking 'out of the box!'

M.

 

[AD_Taylor]

Great! Glad to hear its working for you