1.

Solve : Outlook 2000: How to Attach a File with Macro?

Answer»

Hello, I am using Outlook 2000

Is it possible to Attach a regular .doc file with a MACRO automatically in an Email.

What I am trying to do is create a macro that will automatically write one or two sentences into the body of my message, and then automatically attach a "file"
which is in my "documents" folder called: resume.doc

Could someone show me a sample code that will do this ? I am sending out letters of job interviews and also must attach my resume, to the email. If a macro
can do all this that would be great.

I still have not figured out how to use VBA to program all this stuff into the macro,
but can someone send a sample macro code to do this.

The name of the macro might be : Job resume
The sentence in the body of the message: Attached is my Resume for review
The name of the resume file to attach is: resume.doc

Can someone help. Thankyou, RicTry using the attachments.add method:

Code: [Select]Sub HelloWorldMessage()
Dim msg As Outlook.MailItem
Dim str as String
Set msg = Application.CreateItem(olMailItem)
msg.Subject = "Hello World!"

str = "Dear Personnel," & vbCrLf & vbCrLf
str = str & "Thank you for the opportunity to respond to your help desk position," & vbCrLf
str = str & "I look forward to meeting with you and your staff to discuss my qualifications." & vbCrLf & vbCrLf
str = str & "Sincerely," & vbCrLf
str = str & "Richard"
msg.Body = str

msg.Attachments.Add("c:\documents\resume.doc")

msg.Display
Set msg = Nothing
End Sub

You can fixup the file path to resume.doc if need be.

Good luck.
Speaking of Outlook, how will I set-up an outlook on my pc? I don't KNOW how to set up. Please help.Hi , The Macro you created to attach Files Worked perfectly, Thankyou again,
This would've taken me weeks to figure out. If you know of a good website where I can learn how to step by step create my own macro in outlook 2000 let me know.

Unfortunately, I still have the other problem, "creating a macro button" I did exactly as you MENTIONED, View, Toolbars, Customize, New toolbar,
Then I added a "macro" to the new tool Bar. I tried in 'Undocked" and also
"Docked" positions. When I closed outlook and started it again, it was gone,
Even the new listing I made in "customize" new toolbar was also gone, that
tool also disappeared. I do not know what I am doing wrong, I READ on google that several people had this problem. Am I doing something wrong here, should
I save the tool Bar setting somehow, I do now know where., but the same
disappearance keeps happening again. Anyother possible solutions to this problem. Thankyou, RicHi,

I just WANTED to add, also that even when I select one of the "default"
tool bars, which are "advanced" and "web" , They also disappear
when I restart outlook the next time. The only tool bar that stays
there when I restart is the "Standard" tool bar.



Discussion

No Comment Found