Automatically Sending Emails from Excel

  cvcomposer 16:39 26 Nov 03
Locked

I have been sending spreadsheets as emails from Excel manually. I'd like to create a button/macro to do this automatically, but when I have tried to record the routine nothing appears in the Visual Basic Window. Can anyone help me do this one, please?
Nick

  tbh72 16:53 26 Nov 03

The VBA command you would use to call the email software is

Application.Dialogs(xlDialogSendMail).Show

I have tried to do a copy & paste of a listed e-mail address to no prevail. The above command will simply open the e-mail client attaching the file to the e-mail.

  VoG II 18:43 26 Nov 03

click here

Or search the MrExcel.com site.

  cvcomposer 18:58 27 Nov 03

Thanks for all your help.
Still trying to get my head around all that, but will get there in the end.

Thanks

This thread is now locked and can not be replied to.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

iPhone 9 and beyond: 32 amazing future smartphone developments - graphene, supercapacitor…