More e-mail problems

[Guest]

I'm still having problems e-mail sheets out of Excel.

One set of methods uses activeworkbook.SendMail Recipients:="bla bla bla".
This method always complains that "one of the recipients could not be found",
when the address is in the format (domain changed to protect the innocent)
"(e-mail address removed);[email protected];[email protected]". I have also tried placing
an additional semi at the end, and using commas. No dice.

Additionally this method (.SendMail) does not appear to exist on the Excel
2002 machine I intended it to run on. Does anyone know when .SendMail was
added to Excel?

Another problem is that I tried using Outlook Reunion, but it doesn't seem
to have any effect. I'm still being asked a whole whack of times to click OK.
Any ideas here?

Maury

 

[Tom Ogilvy]

Recipients is looking for an array of strings (email addresses)

Recipients:=Array("(e-mail address removed)","(e-mail address removed)","(e-mail address removed)")

From help on SendMail

Recipients Required Variant. Specifies the name of the recipient as text,
or as an array of text strings if there are multiple recipients. At least
one recipient must be specified, and all recipients are added as To
recipients.

 

[Guest]

That's one, thanks!

 

[Ron de Bruin]

See for the other things

http://www.rondebruin.nl/mail/problems.htm

And

http://www.rondebruin.nl/mail/prevent.htm

 

[Guest]

http://www.rondebruin.nl/mail/problems.htm

(2) seemed interesting, but turned out not to be the problem. The MAPIX is
indeed set to 1, and I could not find any xlb's -- well I did, but only
backups, no originals (weird).

Then I noticed in passing that all components have to be the same version.
It appears someone upgraded Outlook on that machine to 2003, everything else
is 2002. I'm going to assume this is the problem.

You might want to make that -- the version issue -- in its own section, and
I would recommend making it #1 on the list!

You'd think that with 10 years they would have solved DLL hell by now. *sigh*

Maury

 

[Guest]

Ron,
I have to send a file out to a group of people which I have email addresses
for in an Excel sheet. However, there is another group that also needs to get
this file, but I don't have their addresses loaded. The only source is emails
that I have received from them, which are sitting in a folder in Outlook
named Inbox-BFP.
Is there any way to use a macro to look at all emails in this folder,
capture the email address, write it to an Excel spreadsheet and exclude
duplicate email addresses?

Thanks!

David