Outlook Attachment Error

Nikkidoshi

New Member
Joined
Dec 31, 2009
Messages
29
Hi,

I am using Excel and Outlook 2007.

I am trying to send an email attachment through Excel. Please find the code below:

=========================================================

Dim OutlookApp As Object
Dim MItem As Object
Dim cell As Range
Dim email_ As String
Dim subject_ As String
Dim body_ As String
Dim attach_ As String
Dim sAttachment As String

sAttachment = "C:\Documents and Settings\" & usrnm & "\My Documents\" & x2 & ".xlsx"

Dim x, y, z

'Create Outlook object
Set OutlookApp = CreateObject("Outlook.Application")

' Loop through the rows


email_ = ""
subject_ = "'" & x2 & "'"
body_ = ""


'Create Mail Item and send it
Set MItem = OutlookApp.CreateItem(0)
With MItem
.To = email_
.Subject = subject_
.Body = body_
.Attachments.Add sAttachment
End With
MItem.Save
=========================================================

I have a error "You dont have appropriate permissions" while trying to add the attachment.

Please help.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,224,586
Messages
6,179,710
Members
452,939
Latest member
WCrawford

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top