body

I have written code to email and attach a sheet, which works perfectly, except part of the email body per the code below is not being extracted strBody = strBody + "Attached please find Sales for the period _ " + Sheets("Report Name").Range("B8").Text + Sheets("Report...

Hi all, Im trying to create a VBA that inserts a powerpoint slide into the body of an email. Not sure if thats even possible... If possible, it would open a prompt to me select the powerpoint file (using Application.GetOpenFilename maybe), then the macro would copy only the first powerpoint...

Hello, im trying to figure out how to make this code better. currently the code only takes one row,since its based on cell position. Dim i As Integer, Mail_Object, Email_Subject, o As Variant Dim TypeS As String TypeS = ActiveSheet.ListObjects("Orderoversikt").ListColumns(1).Range.Column...

Hey all! Is it possible to send email through SMTP server using CDO (no Outlook!) and insert specific cells in to the body of the email? I have functioning macro for sending emails, but I strugle with the body content. I would like to insert specific region in to the body of the email. Cells...

Can i run my macro in every new workbook. or in already existing workbook. Can any body help in personalize? Thankyou

Hi, I have tried several scripts (and modified them) but I seem to be missing something. I would like to export, from a specified folder in Outlook, specific body items. This is from the body: SM Form 2018-05-11 11:19 AM was submitted by Guest on 5/11/2018 11:19:03 AM (GMT-05:00) US/Eastern...

Hi everyone I have an excel file with several sheets and i want to send every sheet as an attachment to certain people in to and cc in outlook .recipients are different for every sheet and I want to add subject and body of email too.( I want email to be ready with To CC Subject and body and...

Greetings! So I am currently working on a project at my job. It is something that I can do by hand, but requires a tedious amount of time. I'll try to explain briefly and then I need help figuring out how to use formulas to make this easier. We create hot rods from the ground up. We have...

Good morning, Was looking for some help on this small project. I have macro with code that open up an appointment in outlook, but I am looking to auto generate a link to the current worksheet they are in, in the body of the appointment. That way when the appointment comes up they can simply...

Is there a macro that can scan over the context of an e-mail attachment on arrival and delete / move it to a certain folder if it contains it? in a previous thread, i mentioned i receive about 200 emails a day with Text files attached (nothing in the body of the e-mail, only the attached text...

Hi, I want to be able to create a message body for email on a worksheet, which includes hyperlinks. What would be the best method? I'm currently using a Textbox on my Excel sheet to create the body of an email message - example below. I use the 'shapes' object code below to get the text...

I have trhe following code to create an email, add a subject, body and attachment but the line to add the body text is causing an errorSet objMail = objOutlook.CreateItem(0) With objMail .To = strEmail .Subject = Range("Admin_EmailSubject") & " - " & strMonth .Body =...

Hello All, I am struggling with my email macro. I found a great one online that attaches a worksheet as a PDF as I need it to, but cant get the body right. I need certain items in the body to be bold and underlined. After doing some research it seems the only way to accomplish this...

Greetings, I found this code online and it's not working for me :( (Outlook 2016) I have set all macros to allow in the trust center and inserted the code inside Developer-visual basic-this outlook session. ' Declare a variable to save the body content. Dim strBody As String ' Conver the...

Hi there! First post in here, so please bare with me :biggrin::biggrin: I am looking for some help to make a macro that sends multiple charts within the email body. Alternativly, convert a specific range into a PDF (that contains my charts), and send that as an attachment in an email. Any...

Hi, The following Excel code drafts a simple email in Outlook: Sub testerrrrrrrrr() Set myItem = Outlook.CreateItem(olMailItem) myItem.To = "a.b@c.com" myItem.Subject = "Test" myItem.Body = "Two words." myItem.Display End Sub I have a table in Excel (it's a calendar) that I...

Hi Folks The amount I know about writing macros could probably be written on the back of a postage stamp so please bear with me Everything I've ever created has been copied from various websites and through a process of substation, trial and error I've eventually got it working. I've got the...

Hi Every one, I had one very good and almost accurate excel formula for calculating a specific value by index and match function. I lost my external hard drive and that formula too. Can body body help me to do that formula again as I almost not working on excel over two year and above. What I...

Hi All, This is the first time I'm posting on this forum and I'm a Macro dummy right now so I need some help. I have a list of 200+ emails which I would need to send individual emails to as they require different attachment for them. Here is what I have: Column A - To Email Column B - CC...

<tbody> NAME (A1) EMAIL (B1) SUBJECT (C1) TEXT (D1) ATTACHMENT (E1) Andy (A2) ah@mail.com Auto email Dear (insert name) Andy This is a sample of the body text to be included in the email message. Signature Attach PDF 1 Harry hj@mail.com Auto email Dear (insert name) Harry This...