Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

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

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

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

By default Outlook 2016 displays only one time zone in the Calendar. The following article explains how to display two time zones in one calendar view.
I came across an unsolved Outlook issue and here is my solution.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
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

581 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