Is there a way to e-mail a form from VS6 SP5

I have a form that I want the contents to be sent via e-mail to an address on my internal network. The program I am working on is a Help Task database.

Using vbSendMail 3.65.

I am able to send e-mail succesfully, however I need to send all of the values in my controls
as well. For instance I have 8 different text fields that I need to be sent as well as a shortcut that the user receiving the e-mail can click on to open the main help task database or rather the form from my app. This way the tech receiving the ticket can click on the shortcut and be carried directly to the ticket in the database for editing purposes. As I said though I want them to be carried directly to my app to the help task section displaying the exact ticket that was in the subject of the e-mail. Hope this is clear. It sounds confusing to me... :)

"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.

What do the technician's use an E-Mail client? Outlook, Outlook Express? If you are using Outlook, and they all have access to the same network drive, then you could put in the body of the message an entry like this:

<application path>\App.exe 32767. Then the technician can click on the hyperlink and pass the ticket # as a command line parameter to the application.

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Have you created any code for this project yet? Are you just trying to figure out how to get this one thing done?

If the body has text like this:

C:\Apps\HelpDesk\HelpDesk.exe 32767, then the application HelpDesk will be run, and the 32767 will be passed to the application in the command line parameters. For VB6 it could be accessed using the Command() function.

just3082Author Commented: 2003-10-29

I understand this, but somehow or another each time a new ticket is created I've got to get
the path along with the curretn ticket ID in the message body automatically. I don't want the user opening the ticket to have to manually type this each time.....

Right now, This is the code I have... Remember I am still a newbie....

The main form has several text controls, I.e username, location of problem,
description of problem, date and time, The ticket ID field is an autonumber
from my access 2K database, so when the user entering the ticket clicks on
submit trouble ticket, it updates the file adodc1.recordset.updatebatch AddAffectAll
then e-mails the main database and whatever tech name was choosen from the
assign to tech control. I've created the database just haven't added the code for it
yet. Trying to make sure I can pass this data like I want before I get any deeper...