Macro to email Excel file

[pryest]

I am trying to find out if there is a way to setup a macro to send a excel workbook to a specific email address. I have been able to record a macro that will open an email with the file attached using the Send To feature however I would like to also have the email address fill in as well. That way all the user would have to do would be to click Send on the email. Is this even possible? Thanks.

 

[AnotherHiggins]

Play around with this:

ActiveWorkbook.SendMail "Recipient@emailaddress.com", "Subject"

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[AnotherHiggins]

PS - in the future, please post macro/VBA specific questions in forum707, the VBA Visual Basic for Applications (Microsoft) Forum.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[pryest]

Thanks. I didn't realize this was a VBA question since I was just using the macro recording tool but I will certainly do that in the furture. Thanks again!


Mike

 

[AnotherHiggins]

Glad to help!

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.