Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Below is part of a code I am using to send sheets to
specified email addresses using Outlook2000. Everything works great accept when it goes to email the sheets this little box pops up with a status bar saying "A program is trying to automatically send e-mail on your behalf. Do you want to allow this?" I have to wait until the blue status bar gets to 100% and then I can click YES or NO. I dont want this box to pop up at all. Is there a way to send these emails without this popup box asking me if I want to allow this? With olmail .To = cell.Offset(0, 1).Value .Subject = "Your Stats" .Body = "Here are your stats, " & cell.Value .Attachments.Add wb.Path & "\" & wb.Name .Display .Send End With Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Emailing individual sheets in workbooks on Office 2007 | Excel Discussion (Misc queries) | |||
Emailing | Excel Discussion (Misc queries) | |||
hide unnecessary sheets when emailing to others | Excel Worksheet Functions | |||
Emailing using VBA | Excel Programming | |||
Emailing in VBA | Excel Programming |