Sharepoint workflow outgoing email not working

Setup and Purpose:

We are trying to setup a helpdesk in WSS 3.0.  I have created a document library to recieve emails and an issue tracking list to create a new issue for the techs.  The library and issue tracking list are connected through a workflow in SPD.  I have created more workflows to email the end user everytime their issue status changes, but here is my problem.  The "Created by" column in the issue tracking list always has my name and NEVER brings in the end user's name.  I cannot figure out why, but that prevents me using the email To field with the value "Document Library:Created By".  I also see in the document library that I can the E-Mail From and E-Mail Sender columns which accuratly show the end user's email address.  I can bring either of these values into my issue tracking list but I get a workflow error.

Problem: How do I get the end user to recieve the email using my workflow?

I am posting the pics to show an example:


Doc-Library.JPG
Issue-Tracking-List.JPG
Workflow-Error.JPG
SPD-steps.JPG
SPD-email-setup.JPG
someITguysAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AndornagyCommented:
First check if email settings is good in your envirionment.
Is e-mail alerts works well?
You can create working workflow that sends mail to someone (fix user, creator, modifier etc)?

If email setting ok, check how where to find correct user. (in the document library or the issue tracking list). If your workflow connected to another list than the requered username found, You can query it from workflow.

You can also try to transfer user mail drop library to a dedicated field in issue tracking list.
0
someITguysAuthor Commented:
E-mail settings are working.  Everyone gets alerts.

I have already done what you described.  The top 2 pictures are linked together in a workflow.  An email is recieved into the Email Drop library (picture 1) and a new issue is created in the Support Issues list (picture 2). These two pictures are connected by the same email, which you can see by the value 44 in the ID column.

You can see how SPD is trying to create the email in the last picture I posted.  It is based off Support Issues: User Name.
This value is shown in the second picture, but I am getting an error which I posted as the third picture.

Any ideas?
0
AndornagyCommented:
What is the type of User Name field? Did you tried to send e-mail to user in Created By or Modified By field?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

someITguysAuthor Commented:
User Name filed: single line of text.

In my original post, I said that the created by column always has my name and never shows the actual end user's name who sent the email.  If I adjust the workflow to email the person in the "Created by" column, I will recieve the email so that shows the workflow can send the email.  Problem is, I did not send the email to the library so that is why I do not understand why my name shows up in the created by column.  Any ideas?
0
AndornagyCommented:
If e-mail address exists in SharePoint user list it's should be mapped to user name in Created By and Modified By.

I'm can simlpy send scanned pdfs directly from printer to a Document Library (account created for that printer).

Try a new test install it should work.
0
someITguysAuthor Commented:
I tried a new test install and it is still having the same issue.
0
AndornagyCommented:
Try following:

1. New install
2. Create new list
3. Do not Create any workflow
3. Make it e-mail enable, check "Accept e-mail messages based on document library permissions"
4. Send clear text e-mail from simple mail client without attachement (from an existing user in sharepoint site)
5. Check log files if created by and modifed by fields not working properly: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS
0
someITguysAuthor Commented:
I was able to use my current setup by reevaluating the primary/foreign keys between the library and the issue tracking list.  It appears to be working now.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.