Email from workbook

V

VbaHell

Well-known Member
Joined
Jan 30, 2011
Messages
1,220
Hello all

I am currently using a macro to email an active line from a workbook, all works ok except the Gross profit figure show in the email body as 15.6367342

How can I code tag or format the code to show only one decimal point please 15.6

Code: 
 GP = Range("I" & ActiveCell.Row)

objmail.Body = "Can you please process our request:" & vbNewLine & vbNewLine & _
        "Gross Profit % " & "" & GP & "" & vbNewLine & _
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Sort by date Sort by votes
Depending on how you want it to round...

Code: 
GP = Round(Range("I" & ActiveCell.Row),1)

Code: 
GP = RoundUp(Range("I" & ActiveCell.Row),1)

Annnnddddd...

Code: 
GP = RoundDown(Range("I" & ActiveCell.Row),1)
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question Question
Mail merge to insert the picture in the mail body and schedule the email
Replies
0
Views
1K
rafeek4u
R
C
  • Question Question
Send Email from Excel - Launch User's Default Email Client
Replies
3
Views
322
Micron
M
H
  • Question Question
Macro to email Report
Replies
2
Views
542
howard
H
C
  • Question Question
Create code that sends emails and creates a log
Replies
1
Views
277
cokeoverpepsi123
C
C
  • Solved
Adding a Log from user entered comments
Replies
3
Views
496
Tupe77
T

Forum statistics

Threads
1,223,756
Messages
6,174,320
Members
452,555
Latest member
colc007

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top