Help with bulk email macro...deadline approaching!!!

  • Thread starter Thread starter mark sworn
  • Start date Start date
M

mark sworn

HI all. I hope someone can help me. I have tought myself VB in Excel
over the last 2 weeks, and so far compiled 3 succesful macros that
automate my job (departmental resources are being cut, and I have to try
and streamline my job, so i dont get cut!!!)

Basically, one of the statistical reports i have automated needs to be
sent to a column on the excel spreasdsheet range("j" & i), i is a
counter and j is the column with the name in.

The problem: If i use a standard outlook mail through exchange server it
sends fine if the name is in the format "surname,name" I guess cos it
refers to the global address list. However, it sends up that annoying
mail security message. So i used CDO to send the mail, which is fine,
but requires the persons email address.

Now I need a way of either 1: removing the security message from
outlook, or 2: find a way of comparing names from the CDO script to the
Global Address List.

Also, if anyone can tell me how to set the following options on the
mail:

:Read receipt,
:Move sent object to "notifications sent" folder (not a default folder)
: Set a follow up for 1 weeks time
:Set high priority

PLEASE HELP!!!!
 
Am Fri, 29 Jul 2005 07:23:35 -0700 schrieb mark sworn:

Hi Mark,

for the GAl and Exchange I can´t help. Maybe this site is a good starting
point for you: http://www.outlookcode.com/d/sec.htm

Your requested properties are:
Also, if anyone can tell me how to set the following options on the
mail:

:Read receipt,
ReadReceiptRequested

:Move sent object to "notifications sent" folder (not a default folder)
SaveSentMessageFolder

: Set a follow up for 1 weeks time
FlagDueBy

:Set high priority
Click to expand...

Importance
 
Back
Top