VBA excel outlook

[anand_b6802]

Hello guys,

i need to attach excel file to outlook via VBA.

example
A2-subject line
B2-mail id to
c2-mail id cc
D2-excel path which i want attach

in my VBA code wrote as
.attachment.add(range("D2").value

but above code doesn't working.

can any one tell me what would be code for attach excel file.

thank you in advance.

 

[Michael M]

If the file is the active workbook use

 .Attachments.Add ActiveWorkbook.FullName

otherwise, have a look here for code to create a temp file to add as an attachment
Refer to Example 1


Mail the whole workbook

 

[anand_b6802]

Thank you Michael for replied on it.

i will try above mentioned example 1 and let you know the same.

 

[anand_b6802]

its not working.

I need to attached another file not the active excel file.
in marco file I have mentioned excel path which I want to attach.

pls guys tricks or code to attach excel file

Cell "B2" = H:\Working-anand\Anand_04.18.2016.xlsm

 

[Michael M]

Then use

 AttachFile = Sheets("YOURSHEETNAME").Range("D2").Value
 
'your mail code....and  then


 .Attachments.Add AttachFile