+ Reply to Thread
Results 1 to 6 of 6

using VBA with Excel2010 to email attachment referenced in workbook

  1. #1
    Registered User
    Join Date
    08-15-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2010
    Posts
    4

    using VBA with Excel2010 to email attachment referenced in workbook

    Hi all! I'm looking for some help with this one.

    I have a spreadsheet that has data I'm trying to send out to different recipients and include an attachment that is also referenced in the spreadsheet...i.e:

    A B C D E F
    recipient email celldata1 celldata2 celldata3 celldata4 PDF attachment file location (file differs based on results in celldata4)


    The macro would use the recipient email to send celldata 1-4 as part of the body of the email and also include the PDF attachment in the email. I would estimate the total emails sent from this procedure to be somewhere between 25-50 daily.

    I've seen where this is possible, but from what I've seen, as either you name the attachment location in the code, or Excel can send a range of data as an attachment. I haven't found anything that will instruct Excel to add an attachment that is referenced within the spreadsheet.

    Can anyone assist me with this?

    Thank you in advance,
    soundkeyz

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: using VBA with Excel2010 to email attachment referenced in workbook

    Welcome to the board!

    We'll need a realistic sample worksheet(no personal info), but it doesn't sound too difficult.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    08-15-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: using VBA with Excel2010 to email attachment referenced in workbook

    Ok. I've attached an Excel document; no macro in it yet but there will be one to scrub the data and do the email.
    Thank you in advance!

    deed worksheet.xlsm
    Last edited by soundkeyz; 01-17-2014 at 12:19 PM. Reason: spell error

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: using VBA with Excel2010 to email attachment referenced in workbook

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-15-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: using VBA with Excel2010 to email attachment referenced in workbook

    Thank you very much Tinbendr! I really appreciate it!
    Works like a charm.

  6. #6
    Registered User
    Join Date
    08-15-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: using VBA with Excel2010 to email attachment referenced in workbook

    Hi Tinbendr, I forgot about adding the user's signature to the email.
    I've found this online: http://stackoverflow.com/questions/8...ure-in-outlook

    But can't seem to make any amendments to the code to add the signature work. Can you assist with that as well please?

    Thank you in advance.
    soundkeyz

    **UPDATE** I figured it out. Sorry for bothering you -- thank you!

    Please Login or Register  to view this content.
    the rest of it is the same.
    Last edited by soundkeyz; 01-22-2014 at 02:23 PM. Reason: tried to delte post; can only edit

+ 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. Copy selected range from email attachment and paste into closed workbook
    By Lisa4legin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2013, 09:32 AM
  2. Email Open Workbook as an Attachment to Email
    By BazzaBoy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2009, 06:19 PM
  3. Email selected worksheets from a workbook as attachment.
    By osoloco in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-27-2006, 08:20 PM
  4. [SOLVED] Sending 1 worksheet of a workbook as email file attachment
    By JLG in forum Excel General
    Replies: 1
    Last Post: 02-27-2006, 11:20 PM
  5. HOW TO PUT MORE THAN ONE WORKBOOK ATTACHMENT IN AN EMAIL?
    By Traffic Coordinator in forum Excel General
    Replies: 2
    Last Post: 11-15-2005, 05:45 PM

Tags for this Thread

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