Autogenerate mails

Posted on 2003-03-23
Medium Priority
Last Modified: 2010-04-07
I want to send a mail everyday which will:
1 Have a common text and a common group of recepients.
2 should insert a file as text from a common folder (the file will have same name).
3 Should be sent everyday.
4 Exchange server 5.5 client Ms Outlook 2000
Question by:ENPL
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

jessnjeff earned 100 total points
ID: 8197368
The simplest way would be to:

Open an email message, add your fields (cc, subject & attachment), then save as an oft.  

Then you can Go to Tools, Customize, Add a new button then right-click the button and go to Assign hyperlink, then Open.  You want to change it to Existing file or Web page and point to the oft that you created.

Then each day when you open Outlook, click the button to generate your custom email.  

Assisted Solution

by:Todd Wedlake
Todd Wedlake earned 100 total points
ID: 8200026
Here is a simple script that you can use to do what you need.
1. Tools, option, macros, type in a name for it, click create.  This will bring you to the VB editor window.
2. Copy and paste everything here except the sub statement and the end sub statement in between the existing sub and end sub statements.
3. Close VB editor and then create a button to point to this macro.

If you'd like me to email this to you in the proper format, dump your email address here.

Sub attachsnd()
   Dim objOutlk  'Outlook
   Dim objMail   'Email item
   Dim strMsg    'Email message
   Const olMailItem = 0
       Set objOutlk = CreateObject("Outlook.Application")
       Set objMail = objOutlk.CreateItem(olMailItem)
       objMail.To = "whoever@wherever.com"
       objMail.CC = "whoever@wherever.com"
       objMail.Subject = "Enter your subject here" 'subject line goes here.
       strMsg = "Enter your message body here for line1" & vbCrLf  'message body goes here.
       strMsg = strMsg & "Enter your message body here for line2" & vbCrLf
       strMsg = strMsg & "Enter your message body here for line3"  'continue this for as many lines as you need dont' forget the &vbCrLf
   'To add an attachment, use:
       objMail.Attachments.Add ("C:\budget.xls")
       objMail.Body = strMsg
       objMail.Display 'Use this to display before sending email, otherwise call objMail.Send to send without reviewing
   'Clean up here
   Set objMail = Nothing
   Set objOutlk = Nothing

End Sub

I'm not sure how to automate this unless you use something like Automate to kick off the action.

Good luck

Assisted Solution

Vampir earned 100 total points
ID: 8204378
In order to automate asign a Macro to Rules and Alerts.
For example:
on all incoming emails from john@msn.com run the macro: john_stop_emailing_me

Not sure if Outlook 2000 supports it, but 2002 sure does.

But this "formula" is slightly lacking. There doesnt seem to be the method to pick what account to use when sending. The default account is always used, but what if you dont want to use it.
I've already asked this question in the following thread, but no one responded:

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Find out what you should include to make the best professional email signature for your organization.
Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question