+ Reply to Thread
Results 1 to 9 of 9

Using outlook to send emails with attachment

  1. #1
    Registered User
    Join Date
    05-17-2018
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    24

    Using outlook to send emails with attachment

    Hi,
    I tried to look through this forum for self service but wasn't able to find a solution.

    I,m using Outlook and Excel 2016

    Please help! See attachment
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Using outlook to send emails with attachment

    your code seems to work fine?
    just needs a few minor tweak

    Are you not familiar with where to put the CODE?
    Last edited by humdingaling; 05-17-2018 at 11:50 PM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Using outlook to send emails with attachment

    just out of interest
    who provided you with this code?

    it seems pretty much ready to go and custom made for you already...except the body/subject of email

  4. #4
    Registered User
    Join Date
    05-17-2018
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    24

    Re: Using outlook to send emails with attachment

    Hi Thanks for your reply! I found the code on this forum! cant remember which thread though.
    its my first time running macro. Are you able to pls provide user friendly instructions and any suggesting to how to make it easy to run for end user if I was going to off load this task? ie click button to run macro?

    thank you!

  5. #5
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Using outlook to send emails with attachment

    here is a reading to get you started
    there is plenty of material out there

    http://www.rondebruin.nl/win/code.htm
    and
    http://www.rondebruin.nl/win/s1/outlook/tips.htm


    I'm rather surprised how well the code fits your Sample
    i've made some adjustments to the code to suit the additional things you requested

    added a button so you can run it
    though i do recommend you go and at least learn some basics of macro so you understand at least how to alter/amend it yourself should you have problems later on
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-17-2018
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    24

    Re: Using outlook to send emails with attachment

    Thank you sooo much. This is my home work for tonight!

  7. #7
    Registered User
    Join Date
    05-17-2018
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    24

    Re: Using outlook to send emails with attachment

    Question, is there any way to running the Macro without having to click the SEND email button multiple times?

  8. #8
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,905

    Re: Using outlook to send emails with attachment

    If you are certain that all is running smoothly you can replace Display with Send.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  9. #9
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Using outlook to send emails with attachment

    ^what he said
    .display is for your viewing/checking and if you are absolutely sure things are as you want it
    you can make it .send which will just send without displaying

+ 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. Replies: 1
    Last Post: 08-04-2017, 03:02 PM
  2. Outlook 2010, send all emails from outlook outbox
    By joao1232 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-22-2016, 07:33 PM
  3. [SOLVED] Send multiple emails with one attachment each
    By unix17 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2016, 08:02 PM
  4. Macro to send different emails to different people with attachment
    By Dr.Tenma in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-07-2015, 08:15 AM
  5. excel vba to get the emails with attachment in outlook
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 03:37 PM
  6. Send outlook emails with message in cells to individual emails associated with them
    By abinayan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2011, 06:11 AM
  7. Can you tell Excel to send emails through Outlook?
    By Donald S in forum Excel General
    Replies: 1
    Last Post: 06-30-2005, 01:05 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