+ Reply to Thread
Results 1 to 3 of 3

VBA Macro to send To outlook...

  1. #1
    Registered User
    Join Date
    08-27-2014
    Location
    Albany, NY
    MS-Off Ver
    Office 2010
    Posts
    91

    VBA Macro to send To outlook...

    So far I have figured out how to send a file via a Macro that even forces Outlook to open if it isn't already open. However, It will not work with a webmail or anything other then Outlook Proper. So my question is, I would either like to elegantly check for webmail and make that open if Outlook is not found OR pop a window when it cant open outlook that says "send Manually" via MsgBox, but I wanted to toss this out in the Ether for some feedback.

    Code:
    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127

    Re: VBA Macro to send To outlook...

    To give an example of how you can create a popup box, use the following code, adapted of course to your needs.

    Please Login or Register  to view this content.
    As far as sending through webmail, I have written program in the past to log into websites and take certain actions. I'm not sure if it is possible with webmail, and it would be extremely difficult to test since I don't have a webmail platform/account.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,217

    Re: VBA Macro to send To outlook...

    Look at Ron de Bruin's web site. He has pretty much everything you could need for integrating Excel/VBA/Outlook/etc

    http://www.rondebruin.nl/win/section1.htm


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to send mail via outlook
    By dhammdip17a in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-19-2013, 02:40 PM
  2. Macro to re-send emails using Outlook
    By zainnofear1987 in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2012, 12:24 PM
  3. Macro to send email in outlook
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2012, 10:36 AM
  4. outlook redemtion macro cant send mail if outlook is not open ?
    By okl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-03-2010, 07:35 AM
  5. Macro to send to outlook
    By Bill&ted123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2005, 01:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1