| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 68696 | 2006-05-08 03:15:00 | Getting an Excel Macro to send an email | Chris39 (10370) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 453099 | 2006-05-08 03:15:00 | I am running Excel 2003 and microsoft Office Outlook 2003 on Windows XP Pro. I run a macro which updates and saves a number of files on a shared directory. As each file is updated I want to send an email to the users of that file to let them know that it is available. I am currently using the following command Application.Dialogs(xlDialogSendMail).Show This, and everything else I have tried, sends a copy of the workbook. As the workbooks are fairly large I don't want to spend time saving a temp copy before creating the email, I just want to send an email that says " Your file is updated". I thought that this would be easy, but it seems that Excel insists on sending a copy of the workbook or worksheet, Does anyone have an idea that could help me? |
Chris39 (10370) | ||
| 453100 | 2006-05-08 03:33:00 | Several ways of doing it. CDONTS / CDO is a somewhat generic way of doing it. (cdonts.NewMail / cdo.Message) You could also Shell a simple SMTP client, like BLAT. http://www.blat.net/ Or you can make a direct call to Outlook. |
kingdragonfly (309) | ||
| 453101 | 2006-05-08 05:25:00 | Thanks, What would be the code to make a direct call to Outlook? Maybe I need to do a course for Dummies. |
Chris39 (10370) | ||
| 453102 | 2006-05-08 05:56:00 | If I remember, Outlook called externally from, well pretty much anything, will give a dialog box saying something like "Are you a scum-sucking, son-of-a-barnacle, lilly-livered, pantywaist, forked tongued, sorry excuse for a spammer? OK or cancel" I could have the dialog text slightly wrong. Something like BLAT will never complain, though it means using the command shell "Shell", and it's harder/impossible to trap errors. |
kingdragonfly (309) | ||
| 1 | |||||