eMail setup on Terminal Server

[Tom Patten]

I'm trying to setup email in my app that is hosted using Terminal Services.

On my desktop, using

email_smtp_open()

I have it working fine. However when I try it in my server environment, it doesn't work.

What am I missing?

Thanks,

~ Tom

[Tom Patten]

Re: eMail setup on Terminal Server

Is there any reason I would need to have a default email address setup on the serve for this to work?

I don't have permission to get to the "C" drive or My Computer properties.

~ Tom

[martinwcole]

Re: eMail setup on Terminal Server

email Finian - he and I worked out setting up the email properties when running locally/shadowed and on T/S - they will be different

[Tom Patten]

Re: eMail setup on Terminal Server

Thanks Martin. Calling Finian...???

~ Tom

[martinwcole]

Re: eMail setup on Terminal Server

or email him - [email protected]
you run the setup in the autoexec

[Tom Patten]

Re: eMail setup on Terminal Server

I didn't think email_smtp_open() required a email setup. Was I wrong?

~ Tom

[martinwcole]

Re: eMail setup on Terminal Server

Found it - you have to open the port on the server - mandrill on mine is using port 587
call IT - not sure about the port for you.

[Finian Lennon]

Re: eMail setup on Terminal Server

Sorry for not responding sooner. I've been under the weather.

While many ports are open by default on a typical desktop, they are not on Server 2008. If using Gmail, you need 465 and 995 open. Alpha defaults to 25 for smtp_open. And you're right, you don't need a profile to use smtp_open.

[Tom Patten]

Re: eMail setup on Terminal Server

Thanks Martin and Finian; I'll call tomorrow and ask about opening those ports.

So each user/company, may have a different port depending on their email provider. So I'll have to find out their ports, then ask that they be opened.

Thank again, and Finian - hope you're feeling better soon.

~ Tom

[Mike Wilson]

Re: eMail setup on Terminal Server

Thanks Martin and Finian; I'll call tomorrow and ask about opening those ports.

So each user/company, may have a different port depending on their email provider. So I'll have to find out their ports, then ask that they be opened.

Thank again, and Finian - hope you're feeling better soon.

~ Tom

Tom,
The ports are part of the email_smtp_open arguments -

EMAIL_SMTP_OPEN( pSocket as P, SMTP_Server as C [, [COLOR="#FF0000"]Port as N [/COLOR][, Username as C [, Password as C  [, Mode as C ]]]] )

We have each of the function call arguments as a field in our "Staff" table and the values pertinent to each staff member loads into global variables during login as part of the autoexec. The email_smtp_open() function call is then a generic call within scripts, with the value for each arguments being supplied by the values in the global variables. Since email is performed extensively within our app, this seems to work well, and adding and maintaining the argument values a process of maintaining the Staff table, not the script code.

[Tom Patten]

Re: eMail setup on Terminal Server

So I have the above working "silently".

I don't see a setting within the email_smtp_open() function to not run silently and show the email template and let the user edit the message then click the SEND button.

How can I see the email prior to it being sent?

Thanks ~ Tom

[Finian Lennon]

Re: eMail setup on Terminal Server

If you want to use email_smtp_open etc. and have bells and whistles, I think you'll need to build your own interface. Otherwise you're back with profiles and/or connecting to the external email program.

You could do this with a simple xdialog or form to display the From/To, message text etc and pass those variables to the email_smtp_open function.

[Tom Patten]

Re: eMail setup on Terminal Server

Finian,

I just started down that road this morning. I'm having a problem with "seeing" my variables on the Dialog form.

dim pm as P
	pm.attachments = ""
	pm.lrelated = .T.
	pm.from = "[email protected]"
	pm.from_alias = "PALs Software"
	pm.to = "[email protected]
	pm.subject = "Subject"
	pm.message ="My message"

I open a form in Dialog Mode. How do I dim the above variables so I can see them on the dialog form?

Thanks again,

~ Tom

[Tom Patten]

Re: eMail setup on Terminal Server

got it. I had to go for a walk to wake up!

After I loaded the form as Dialog, I just filled the fields using Frm:vSubject.text = "Subject" the showing the form. Piece of cake!

Thanks again.

~ Tom

[Tom Patten]

Re: eMail setup on Terminal Server

OOps... one more question

How can I develop an input dialog, like ui_get_text() to get rich text to insert into the body of an email. I'd prefer not to add another field to a table. Is there a variable setup for rich text?

pm.message = My_Rich_Text variable.

Thanks ~ Tom