|
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.
|