+ Reply to Thread
Results 1 to 7 of 7

auto mail in excel

  1. #1
    Registered User
    Join Date
    12-15-2014
    Location
    belgium
    MS-Off Ver
    2003
    Posts
    75

    auto mail in excel

    Might be an impossible isseu.
    Is it possible to have a cell containig a function that opens a mailbox to mail to a given adress with in attach the excel file

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: auto mail in excel

    for example
    http://www.excelforum.com/search.php?searchid=6539378

  3. #3
    Registered User
    Join Date
    12-15-2014
    Location
    belgium
    MS-Off Ver
    2003
    Posts
    75

    Re: auto mail in excel

    the link does not work

  4. #4
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: auto mail in excel

    Hi fla-ts,

    See the attached zip file which contains an Excel file and two sample attachment files. This should get you started.
    The Outlook specific code is included below:

    When using the file:
    a. All 3 files have to be in the same folder.
    b. Change the email addresses in the Excel file as required.

    In ordinary code Module (excerpt) ModOutlookEmail:
    Please Login or Register  to view this content.
    Lewis
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-15-2014
    Location
    belgium
    MS-Off Ver
    2003
    Posts
    75

    Re: auto mail in excel

    I would have a close look, maybe I can start with it, however I'm afraid it only works with "outlook" and I cannot know wich email program uses

  6. #6
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: auto mail in excel

    however I'm afraid it only works with "outlook"
    The code only works with Outlook. There is other software that uses different code (that I have never gotten to work). The other code requires that the sender knows the communication protocols that his e-mail provider uses.

    I am afraid you are probably not going to find a successful solution to your problem.

  7. #7
    Registered User
    Join Date
    12-15-2014
    Location
    belgium
    MS-Off Ver
    2003
    Posts
    75

    Re: auto mail in excel

    I think so also. Maybe I have to make a kind of contact form on my website people can use to add my requested information and send it in this way.
    That also isn't easy to make

+ 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. Cant get the auto mail from excel via outlook to work
    By JimmyQ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-22-2014, 02:37 AM
  2. Auto-send mail with attachement using VBA in Excel does not work on some PCs
    By Dominozzz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2013, 01:52 PM
  3. Excel Macro for auto e-mail via outlook
    By Tgteer1619 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-14-2012, 10:49 PM
  4. Auto Populate E-Mail From Excel 2010 - Possible?
    By JerLon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-13-2012, 09:15 PM
  5. Replies: 0
    Last Post: 07-22-2012, 01:34 PM
  6. Replies: 1
    Last Post: 07-22-2012, 09:26 AM
  7. [SOLVED] How do I permanently deactivate auto e-mail in Excel?
    By SantoshDreams in forum Excel General
    Replies: 2
    Last Post: 08-19-2006, 02:25 PM

Tags for this Thread

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