Results 1 to 2 of 2

Request 1: Sending email with a click (Request 2/Macro 2: Capture Response)

Threaded View

  1. #1
    Registered User
    Join Date
    10-03-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    98

    Request 1: Sending email with a click (Request 2/Macro 2: Capture Response)

    Hello Experts,

    I am looking for some help from VBA experts. I hope someone can help. Thank you and appreciate your help in advance!

    Requirement 1:
    I need to have URL (say name: Send Email) in Column J (in cells J2, J3, J4 etc.). When I click that URL (say J3) it should take contents from that specific row (#3) and should generate an email like below

    Email Subject: '[Contents from A3] + [Contents from C3] + Ownership Determination?'
    Body: Hello Users,
    Can you please check below and lets us which company owns the website? (Company 1 or Company 2?)
    There should a table (A3 to C3)

    Regards,
    John Doe


    Please check below screenshot for more details
    Email Request_Image 1.PNG

    Above is my requirement 1 and below is my Requirement 2
    Once after I sent email and if users response back I want to capture that in a different sheet (Email Response). I want a Macro for a specific Folder in my Outlook (say Ownership Determination Response), whatever emails there in that folder needs to have those contents copied over to Spreadsheet (to sheet name 'Email Response'). Email Subject needs to copied to Column A which has free cell and Subject should be copied to its adjacent cell in Column B). Thanks in advance!

    I am also attaching my SAMPLE spreadsheet.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Email sending For Each help request
    By tmsmyr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2022, 09:33 AM
  2. Passing a JSON request per row to an API and parsing response
    By johnmcafee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2020, 06:26 AM
  3. problem with web request and accented character in response
    By SkinnyV in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-09-2018, 11:55 AM
  4. [error while processing request] wrong response
    By CorinneGermany in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2015, 03:02 AM
  5. SENDING HTTP REQUEST and GETTING RESPONSE
    By downtown1933 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2013, 09:43 PM
  6. Email Notification when a request has been submitted via a macro button?
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2011, 01:07 PM
  7. Sending a Meeting Request from Excel
    By jason_kelly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2010, 09:41 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