Environ(UserName) on Remote Machine

[Rekd]

I've been working on a project for buyers to get data using a userform. If the data they want isn't there they can send a request to me via email to get the data entered.

In the sendmail sub I used

sUserName = Environ("UserName") & "@company.com"

and it worked while I was testing it locally. But when I put the file on the network and the buyer's try to send email it doesn't work. In fact, even though I've put

On Error Resume Next

A few lines above that call to Environ it still errors. Is there another way to get the user name on the remote machines? I don't want the user to have to do anything, well, except to accept the security prompts when I try to access their Outlook via VBA.

 

[Smitty]

Why not just have them enter their e-mail address on the form?

Especially if you're working across companies, even divisions of the same company, it's unlikely they'll follow the same e-mail naming conventions or logins. There's probably a substantially greater propensity for failure than success with environ in this case.

 

[Rekd]

Why not just have them enter their e-mail address on the form?

Especially if you're working across companies, even divisions of the same company, it's unlikely they'll follow the same e-mail naming conventions or logins. There's probably a substantially greater propensity for failure than success with environ in this case.

I'm trying to eliminate all user input except standard IO. The buyers are all within a few cubes of me and we all have the same standards for addresses; first initial + last name @ company.com.

I suppose I could use Application.Userame then parse their names to build the address.

 

[Smitty]

OK - Then I'd go to one of their machines and see what environ is actually returning.

Or since they're employees, build an employee list that they can select from in a ComboBox. You can pull the e-mail address from a vlookup table.

 

[Rekd]

OK - Then I'd go to one of their machines and see what environ is actually returning.

I did. When run the command from a macro I created on their machine it returns the name as expected. When the macro created on MY machine runs on HIS machine it errors.

Or since they're employees, build an employee list that they can select from in a ComboBox. You can pull the e-mail address from a vlookup table.

That is certainly an option. I could probably narrow it down enough with Application.Username to auto-select their name and they can just click a verify or something.

Now, if I could just get around the Microsoft security when I try to access Outlook.

 

[Mike Blackman]

Hi,

Use the code on Ron de Bruin's site here, his mailers don't trigger the Outlook security.

 

[Andrew Poulsom]

Now, if I could just get around the Microsoft security when I try to access Outlook.

Look here:

http://www.rondebruin.nl/cdo.htm

 

[Rekd]

Oooohhh...

Very nice! Who is this Ron guy and how come I haven't found his awesome pages in my searches over the last few months...?