email active workbook

Hello, i need some help for VBA in my excel i would like to draft in my email in this format from my excel here the example to be send to the emails To: [Send Email To] CC: [CC To] Subject: [Doc. No.] Require Your Attention - [Error Message] Dear Sir/Mdam, We would like to inform the...

Hello everyone! I have a problem that has me pulling my hair out. I have a spreadsheet with some buttons, when you click the buttons various reports are emailed off to various people. The email is made perfectly, and the file is attached ready to go, except there are two niggles. First the...

I have a master sheet and a code to split it into separate sheet based on reviewer names, now i need to send all the splitted sheet to each of the reviewers based on sheet names, example: sheet named raj must be sent to raj@gmail.com, sheet named ravi must be sent to ravi@gmail.com I managed to...

Hi, I have created some code via VBA that would copy a range (A1:Q120) within my excel worksheet (this worksheet is a dashboard, containing graphs and images) as a picture and then opens up an outlook email and pastes this image within the body of the email - and centers it, like a newsletter...

Hi there, I am using the code below to email out a report (using task scheduler & macro launcher to email our daily). The report I'm emailing out contains macro buttons, relating to two modules (Module1 and Module2). The code below works as far as sending the workbook as an attachment, but...

Hello, I am looking to create a macro that selects a specific range (2 columns) and emails it to phone numbers (e.g. 5551112222@vtext.com). The range looks something like this: Apples 5% Oranges 4% Bananas 4% Tomatos 3% Other 50% The issue i'm running into is the fact that it needs...

Hello everybody, Goal: I am currently trying to create a command button in Excel that, when one clicks on it, sends out an email to me with an order that one has entered into Excel. The following link here: Using Excel VBA to Send Emails with Attachments - wellsr.com has a nice VBA code that...

Hello When I run my send email macro, the excel sheet data that populates in the email body has errors in one column. Eg: In the workbook the values are reflecting as <tbody> 3/9/2019 22:00 </tbody> But in the email body the values are reflecting as 3/8/2015 22:00 Why is this happening...

Hi Guys! I looked everywhere and couldn't find the answer I was looking for. I need to create a macro which will send an e-mail from excel sheet. The subject should contain pre-determined text, the current date and values(numbers) from two cells. The body should have a header(range A2:L2) and a...

Hi All, I am trying to send a worksheet via email from my userform. The coding I currently have fills in the cells o.k but I then want that sheet to be attached to an email and sent. any help/codes are appreciated. Thanks.

So I have this code so when I click on a button the macro runs. This is my code: Sub Mail_Sheet_Outlook_Body() 'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm 'Don't forget to copy the function RangetoHTML in the module. 'Working in Excel 2000-2016 Dim rng As Range...

Hey guys, I have been hitting my head with it, but being completely ignorant about VBA, it's become almost impossible for me to solve it on my own. I have an inventory and the column O has a status showing which have reached their minimum qty. So I would need the automation to send an email...

I hope you can help. I have a piece of code. Essentially what it does is, it opens a dialog box that allows a user to select an excel sheet, then it goes out to the country column (11) filters it, then copies and pastes that country into a new workbook, names the new workbook after that country...

Hello i have to create a vba code to send email of the first row then next row then so on i have created a vba code but i have few issues the values in COLUMN A SHOULD GO TO THE "TO" FILED OF THE OUT LOOK and B C D E F G H should go to the body of the OUTLOOK please help me out and i will post...

Hello the below given program is to send email via outlook and it is working fine but i have to add two more feature 1. The excel file i am currently working on should get automatically attached to the email 2.i need to send this email to multiple users <code class="vb keyword"...

Good morning everyone Apologies in advance if this is a real beginners error but I just can't figure out why its doing this and its causing quite a problem. Background: I have a master spreadsheet that we use to plan transport based on product lines that have been requested by my customer and...

Hello, This is my first post. I am managing a group of 20 salesmen. I want to send each salesmen a report every week but I don't want to do it manually. Is there an easier way to do this? I am thinking VBA and advanced filter. How do i post my spreadsheet? Thanks,

I have a problem creating an email with excel vba. I wrote code and created an addin that works on my computer. I have Excel 2013 and Outlook 2013. The addin also works on excel 2010 with outlook 2010. The problem I am having is some of the computers in our company have Office 2013...

Hi Folks I'm wanting to create a button in excel that, when clicked by the user, will automatically send an email from their outlook to a specified address. I also want to have the subject field and email content already formatted and chosen by myself. Finally if this could be done...

I'm trying to adopt a code found on the internet and would really need some help as I'm totally new to VBA. I'm in need of sending excel worksheet as attachement to email and below snip from the code is what I've looked at. I would need to send email to the adrdress in Cell H11 with CC to...