emailing questions

UPN

Board Regular
Joined
May 14, 2006
Messages
138
This code is part of a macro i have, that works great. 2 questions, the one i think i know but want to make sure
If I make read receipt FALSE, this will not ask for read receipt RIGHT?

Is there a way that i can place in the subject line the actual file name?


Code:
With oMail
    .To = "ME@cbilling.com"
    .To = Range("B1").Value
    
    .CC = "you@billing.com"
    .CC = Range("B2").Value
    
    .ReadReceiptRequested = True
    .ReadReceiptRequested = Range("B3").Value
    
    .Subject = "File for " & Format$(Date, "mmm dd, yyy")
    .Subject = Range("B4").Value
    
    .Body = "Here is the shpping log"
    .Body = Range("B5").Value
    
    .Sensitivity = 3                'olConfidential = 3
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

UPN

Board Regular
Joined
May 14, 2006
Messages
138
Sorry

Sorry wbout this, when I meant filename, I meant the filename of the attachment

I want this to be in the subject line
 

Watch MrExcel Video

Forum statistics

Threads
1,111,911
Messages
5,541,543
Members
410,549
Latest member
Anaarchie
Top