A button to create email

[-emma-]

Hi all,

I would usually try and work these kind of things out myself but am faced with a very tight deadline for this to be completed.

I have a very simple form that users complete and then hit a button which will send content of the form to a specific email address.

The form is located in range B2:K12 which is what I require to be included in the body of the email.

Cells E7 & E9 are the cells containing information that I require in the subject line of the email, separated by a dash. Below is an example of the subject line:

E7 = John Smith
E9 = AW761WHA
Subject line = John Smith -

AW761WHA

Is there anyone out there that could knock this out in super fast time for me please? I'd be forever grateful.

Thank you for reading

Emma​

 

[dmt32]

Hi,

Have a look at Example 2 on Ron de Bruin's site which may do what you want

Home | Ron de Bruin Excel Automation

Welcome to https://www.rondebruin.nl

www.rondebruin.nl

Dave

 

[-emma-]

Hi,

Have a look at Example 2 on Ron de Bruin's site which may do what you want

Home | Ron de Bruin Excel Automation

Welcome to https://www.rondebruin.nl

www.rondebruin.nl

Dave

Hi, thanks for your quick response. It does work for the most part - its the subject part that I cannot work out now! But once again, thanks for the help

 

[dmt32]

Hi, thanks for your quick response. It does work for the most part - its the subject part that I cannot work out now! But once again, thanks for the help

Hi try

.Subject = Range("E7").Value & " - " & Range("E9").Value

Assumes your form sheet is the activesheet otherwise, you will need to qualify the ranges.

Dave

 

[-emma-]

Hi try

.Subject = Range("E7").Value & " - " & Range("E9").Value

Assumes your form sheet is the activesheet otherwise, you will need to qualify the ranges.

Dave

This works perfecty! Thank you, thank you, thank you and thank you!

From a Happy Emma (which doesn't often happen ?)

 

[dmt32]

This works perfecty! Thank you, thank you, thank you and thank you!

From a Happy Emma (which doesn't often happen ?)

Glad to have been of some help

many thanks for feedback

Keep safe

Dave