+ Reply to Thread
Results 1 to 4 of 4

Export Excel sheets and send them as emails (Loop)

  1. #1
    Registered User
    Join Date
    09-06-2017
    Location
    New York
    MS-Off Ver
    MS Office 2010
    Posts
    10

    Export Excel sheets and send them as emails (Loop)

    Dear all,

    I'm trying to automate a report production and distribution process. What I need to do is create a macro that goes through the list (1 to 20) and for each row creates a new file (separate Excel file), pastes 2 tabs from the current one (sheet names are in columns J and K) and saves it under the filename in column E. Then the macro should open Outlook and create an email by attaching the file and using the subject, distribution list, email body as shown in the table.

    I'd highly appreciate any help as I've been bumping my head with this for a while.
    excel111.PNG

    Thanks,
    Alex

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,879

    Re: Export Excel sheets and send them as emails (Loop)

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    09-06-2017
    Location
    New York
    MS-Off Ver
    MS Office 2010
    Posts
    10

    Re: Export Excel sheets and send them as emails (Loop)

    Thank you alansidman for your suggestion. I've attached an Excel file. Below is the code that I have so far (not much...). I haven't reached the loop and send emails part yet.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-06-2017
    Location
    New York
    MS-Off Ver
    MS Office 2010
    Posts
    10

    Re: Export Excel sheets and send them as emails (Loop)

    Anyone has an idea?

+ 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. Excel vba to auto-send customer emails (duplicate emails issue)
    By nadz84 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-29-2015, 10:08 AM
  2. Send Emails once expiry date is reached, and generate report based on emails sent
    By demonicscorpion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 05:36 AM
  3. [SOLVED] Macro To Send Emails with PDF: Multiple Emails and PDF's
    By totoga12 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-19-2014, 06:13 PM
  4. [SOLVED] Loop through rows/columns H and K in filtered table and send emails - Help Please Gurus ;)
    By Alina1404 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2012, 03:23 AM
  5. 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
  6. Sending macro emails using excel: Send emails with their passwords.
    By loveisblind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 03:16 PM
  7. [SOLVED] Can Excel send out emails?
    By Robert Hodge in forum Excel General
    Replies: 1
    Last Post: 01-10-2006, 06:15 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