Email newly created line in excel workbook

**klospros** · 11-20-2014, 07:21 AM

Hi all,

I am very new to excel but am in the process of working on a project where I need to create an excel DataBase and then send the newest submission to another department using the sendmail function.

I have the form working fine and it correctly writes to the DB, however the present script I use for SendMail is only for the active workbook.

The code I am using is as follows:

Please Login or Register  to view this content.

Can you please advise if I can actually just send the newest line created in excel from the active workbook as opposed to the whole active workbook?

I have looked in the forum but unable to find the answer as of yet, it is possible I am looking in the wrong part of forum.

**daffodil11** · 11-20-2014, 06:51 PM

I pulled this from the MSDN, and modified the range to target the row currently targeted.

Please Login or Register  to view this content.

**klospros** · 11-21-2014, 06:57 AM

Thank you for your reply.

I have tried the code and it sends the email fine, however it only sends an empty worksheet called 'sheet1' as oppoesed to the line from a worksheet called 'DevRequests'

Ideally what I would like to achieve, is to pull the data from the subject field and add to the subjuct line in outlook, anf the data in the description field into the body within outlook but only for the newly created line. I have no idea if this is possible though?

The code I am using to submit the data from the form is as follows:

Please Login or Register  to view this content.

I am have created the form that is activated from a worksheet called 'Dev Submission' that then writes the data to the 'DevRequests' worksheet.

Thanks you in advance.

**daffodil11** · 11-21-2014, 10:33 AM

Okay, so I actually ripped the code apart and made it work for you.

Right before you copy your code over to the database:

Please Login or Register  to view this content.

**klospros** · 11-21-2014, 11:16 AM

Thank you so much, that works perfectly. I am so grateful

**daffodil11** · 11-21-2014, 11:48 AM

I knew nothing about the email merge running into this, so I learned a bunch too.

Putting that snippet into the code vault!

Email newly created line in excel workbook

LinkBack

Thread Tools

Rate This Thread

Display

Email newly created line in excel workbook

Re: Email newly created line in excel workbook

Re: Email newly created line in excel workbook

Re: Email newly created line in excel workbook

Re: Email newly created line in excel workbook

Re: Email newly created line in excel workbook

Thread Information

Users Browsing this Thread

Similar Threads

Extract data from a newly created workbook with a changing name based on a date.

use existing creation date of workbook with newly created .saveas workbook

Using a macro to add code to a newly created workbook.

Open newly created macro from new workbook

Saving Workbook in newly created directory

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions