+ Reply to Thread
Results 1 to 2 of 2

Attaching data from a worksheet using VBA to an email through Outlook

  1. #1
    Registered User
    Join Date
    08-16-2014
    Location
    Australia
    MS-Off Ver
    2010/2013
    Posts
    7

    Attaching data from a worksheet using VBA to an email through Outlook

    Hi all,

    I want to link VBA to Outlook and I am wondering if this is even possible?

    I have created a database with a few Userforms. One of the Userforms has a CommandButton which once pressed, I want to send all the data that is in the relevant column on Sheet1 (called "Details") to my work email. Can anybody help me with this? I have done some independent research to no avail...

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

    Re: Attaching data from a worksheet using VBA to an email through Outlook

    yes plausible

    Ron is often referred to on this matter
    http://www.rondebruin.nl/win/s1/outlook/mail.htm

    numerous examples on this forum...i dont see anything particular different to previous forum posts examples

    essentially press button
    extract certain data from sheet to put into email to send
    is that the gist of it?

    if above link and search in these forums doesnt fruit you anything to help in your particular example
    please post sample spreadsheet with sanitised data with your proposed outcome
    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.

+ 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: 0
    Last Post: 07-02-2014, 03:04 PM
  2. Outlook macro when attaching a document to an email
    By zarake in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2013, 07:41 PM
  3. Macro for attaching files into Outlook email - 95% complete but....
    By heatwave in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2013, 01:30 AM
  4. Attaching a Worksheet in Outlook 2010
    By birchetts in forum Excel General
    Replies: 3
    Last Post: 03-12-2012, 05:41 AM
  5. Attaching One Worksheet to Email
    By KeshnerH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2005, 04:06 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