Specify email address on button click 1

[jpkeller55]

I have the following very simple code on a button in Excel for a user to click on to Email the excel (2003) file in Outlook. This works fine. I would like to have Outlook open with the file attached as it does now but with a specific email address populated in the TO: field of Outlook (2003). Is this possible?

 Application.Dialogs(xlDialogSendMail).Show

 

[HarleyQuinn]

You're able to use the arguements for that method, e.g.

Application.Dialogs(xlDialogSendMail).Show arg1:="Harley@uinn.com"

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[jpkeller55]

This is interesting. I can get this code to work on my personal computer but it does not populate anything on my work computer that is hooked up to the company network. Is the fact that this is on a VPN network have anything to do with it not working?

 

[HarleyQuinn]

Shouldn't as far as I know.

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[jpkeller55]

Is the another method to accomplish this besides the code above?

 

[jpkeller55]

Not sure why this worked, but I deleted the old macro code and started over. Now it works. Thanks Harely.

JK

 

[HarleyQuinn]

You're welcome, glad I could help

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.