-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
.attachments.add
-
T
VBA Send_Emails() Help
Happy Friday, I have a sheet to send monthly and I want to create a button and a code to send it to the same people every month. The button works but the code isn't EXACTLY how I want it. Here are my issues: 1) My signature is not showing up 2) I can't get the font to be Arial, 11. Sub...- Tvalli
- Thread
- .htmlbody dim end outlookmail
- Replies: 1
- Forum: Excel Questions
-
W
Emailing Attachments
Currently i am manually updating my email code evertyime I cahnge the attached files I am needing to send. So i was wondering, hoc can i attache all files in a folder automatically to an email? Line 1 is an example of teh attachement code, lin two is what ai was thinkiong of but does not...- wmtsub
- Thread
- code email files teh
- Replies: 2
- Forum: Excel Questions
-
V
Only run macro if the first column contains text - VBA Excel to Outlook
Hi All, This is my current code: 'binding Sub bulk_email() On Error Resume Next Dim o As Outlook.Application Set o = New Outlook.Application Dim omail As Outlook.MailItem Dim Signature As String Dim i As Long For i = 2 To Range("A10000").End(xlUp).Row Set omail =...- VBAn00bheh
- Thread
- cellsi dim omail run
- Replies: 1
- Forum: Excel Questions
-
K
Email attachment.add cell value runtime error 13 type mismatch
Hi! I would like to attach different types of file to my emails. This code worked well untill I placed the attachment adding. .Attachments.Add "D:\8" & Range("S12").Value After that it was stucked on runtime error 13 type mismatch. Can anybody help me with this? Sub Send_Mail2() ' '...- Kjuri
- Thread
- mail runtime error 13 mismatch
- Replies: 1
- Forum: General Discussion & Other Applications
-
S
using .htmlbody instead of .body in my email excel sheet macro using OutMail
In the code below I specify the body of the email using a series of cell references from my workbook. Can I use the same approach and use .HTMLbody instead of .Body. I want to be able to format the body of my message or make it appear more aesthetically pleasing for the recipient A line below...- scassells
- Thread
- .body .htmlbody rangew16 vbnewline
- Replies: 2
- Forum: General Discussion & Other Applications
-
G
Adding email addresses based on cell references to a mail button
I have form that has a button that sends an email to those completing the form. The relevant section looks like this: With OutMail .To = "James.jones@urcca.edu" .CC = "" .BCC = "" .Subject = "Successful Submission: " & Sheet1.Range("j10") .Body = strbody...- Godot60
- Thread
- add email form
- Replies: 6
- Forum: General Discussion & Other Applications
-
A
I can't get my attachments to work when emailing from excel
This line of code is not running: .Attachments.Add Range("I" & i).Value within this code: Sub CreateMail() Dim objOutlook As Object Dim objMail As Object Dim i As Integer Const olMailItem As Long = 0 Dim strbody As String For i...- Alphaboss7
- Thread
- code i.value running suggestions
- Replies: 1
- Forum: Excel Questions
-
B
problem with attaching files to email VBA excel
Hello I am trying to send an email via excel vba. Everything works fine but the attachments won't attach for some reason. I am sending htis email out everyday so the file will have a name that varies according to the date so I am referencing cells within the sheet that the macro looks up but...- ben_sorensen
- Thread
- email sheetssingle.cells2 sheetssinlge.cells2 vbnewline
- Replies: 1
- Forum: Excel Questions
