+ Reply to Thread
Results 1 to 3 of 3

email excel doc with default users email

  1. #1
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2016
    Posts
    143

    email excel doc with default users email

    Hi,

    I have 2 macros that work well individually but when I merge them I cant get it to do what I want.
    Id like the macro to save the current workbook then email it but adding the users default Outlook email address. As a business we have to set an email signature as standard.
    Can someone help with the following code please.
    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    02-24-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    317

    Re: email excel doc with default users email

    It looks like you have researched this a bit because your code resembles that of Ron de Bruin's.

    Did you see this part of his webpage that covers what you seek? See example 2.

    http://www.rondebruin.nl/win/s1/outlook/signature.htm
    If I helped in any way, please click the star

  3. #3
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2016
    Posts
    143

    Re: email excel doc with default users email

    Hi Jim,

    Thats correct I did use his code but didnt see this. Thanks.


+ 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. VBA to perform mass email functions with Apple Mail (Macbook default email program)
    By thianphat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2014, 04:09 PM
  2. send selected range in email with default outlook email signature included
    By mdsickler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 10:50 PM
  3. Unable to link default email signature to email
    By paxile2k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2010, 06:52 PM
  4. Sending Email Dependent on Default Email Client
    By Julesdude in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-30-2010, 06:51 AM
  5. Sending email using users preferred email client
    By deadlyduck in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2009, 06:29 AM

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