+ Reply to Thread
Results 1 to 6 of 6

Group Email through Outlook with attachments

  1. #1
    Registered User
    Join Date
    03-06-2008
    Posts
    20

    Group Email through Outlook with attachments

    Dear friends,

    I need to send a lot of similar emails every month in Outlook. I want to write a macro every time when I manually upload attachments and select recipients. But I am a newbie in VBA and not quite familiar with the codes.

    Would you please help? Attached please find the file. Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Group Email through Outlook with attachments

    I'm struggling with your instructions. Your sheet has attachments listed but they aren't filepaths and there are no email addresses.

    Are you trying to send one email to every email address listed in G11:V15?
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Registered User
    Join Date
    03-06-2008
    Posts
    20

    Re: Group Email through Outlook with attachments

    Thank you Solus for your reply. Yes, from Row 11, one row is one email and recipients of the email are from Column G:V.
    Last edited by susuyesyes; 04-07-2014 at 02:17 PM.

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Group Email through Outlook with attachments

    Please place sample data in all the fields you'll have filled out.

  5. #5
    Registered User
    Join Date
    03-06-2008
    Posts
    20

    Re: Group Email through Outlook with attachments

    Thank you again Solus. Sample data have been placed. Please help.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-06-2008
    Posts
    20

    Re: Group Email through Outlook with attachments

    Please help. Any hints or tips are all greatly appreciated. Thank you.

+ 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. [SOLVED] Need help in editing the current Macro to send email with multiple attachments frm Outlook
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2014, 11:25 AM
  2. Outlook: How to set a specific group of members/email address
    By Ericng in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 07-10-2013, 05:07 AM
  3. Extract msg attachments from outlook email
    By haribo83 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-02-2012, 10:53 AM
  4. [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
  5. adding multiple attachments to a macro in excel for a email using outlook
    By ccbltdneedhelp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2009, 11:03 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