+ Reply to Thread
Results 1 to 3 of 3

Email Attachments with Excel

  1. #1
    Registered User
    Join Date
    04-20-2021
    Location
    US
    MS-Off Ver
    Office 365
    Posts
    30

    Email Attachments with Excel

    Guys, quick question been driving me crazy for days... So I recently setup a worksheet with macros that takes information from the sheet and applies them to a outlook email, the problem I am having is I need to attach numerous files all located in one folder to the email... Now the names of the files change with each email I send, But the main folder name never changes, I have the concept of attaching one file, but I need to attach all the files in the folder..... Some help would greatly be appreciated. Thanks in advance.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Email Attachments with Excel

    .
    Look at this resource : https://www.mrexcel.com/board/thread...-email.361072/

  3. #3
    Registered User
    Join Date
    04-20-2021
    Location
    US
    MS-Off Ver
    Office 365
    Posts
    30

    Re: Email Attachments with Excel

    Attached is my code, I have also posted in Commercial Forum... If someone wants to use my points not sure how that process works.... Perhaps someone wants to re-write for this to work correctly?


    Sub Email_From_Excel_Basic()


    Dim emailApplication As Object
    Dim emailItem As Object

    Set emailApplication = CreateObject("Outlook.Application")
    Set emailItem = emailApplication.CreateItem(0)



    emailItem.To = Range("AC15").Value

    emailItem.Subject = Range("D10").Value

    emailItem.Display

    Set emailItem = Nothing
    Set emailApplication = Nothing

    Range("D13:K39").Select
    Selection.Copy

    End Sub

+ 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. Using .attachments.add to attach an excel file to an outlook email
    By mirandajean in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-19-2017, 11:48 AM
  2. move Excel attachments in email to a folder
    By Goodstart14 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2014, 09:56 AM
  3. [SOLVED] How to send an email from excel with two unique attachments
    By cyberelf77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2013, 09:51 AM
  4. Sending Email with Multiple Attachments from Excel
    By Lisa4legin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-29-2013, 03:24 PM
  5. Replies: 0
    Last Post: 02-21-2013, 04:46 AM
  6. [SOLVED] Excel Macro to download email attachments from MS Outlook.
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-06-2010, 02:10 PM
  7. Email merging Excel attachments
    By nc in forum Excel General
    Replies: 0
    Last Post: 04-13-2005, 05:06 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