Specify server in SendMail?

[andy]

How can I specify the server in the email SendMail? If a
user doesn't have a email client installed on a machine
and Submits this form, which triggers the SendMail module,
they get a setup wizard asking to setup email, address,
SMTP, etc.
If I could specify what server, and the email address the
form is to be sent to then this should work.

Could someone give me the syntax please? or advise how to
get this accomplished?

This is my code -
ActiveWorkbook.SendMail "(e-mail address removed)", "Account
Form"

Thank you in advance
God bless you

 

[Ron de Bruin]

Hi andy

Try CDO to send Mail
You can fill in your SMTP server in the code

See the CDO link on this page
http://www.rondebruin.nl/sendmail.htm

 

[Guest]

Ron,

Thank you very much for your reply. Your site is
excellent! I am having a problem with the code. Everything
works well except when I close the Excel form (which will
be in our intranet) and open the mail which has the
attachment, it openswith a dialog box with the following
message "The workbook you opened contains automatic links
to information in another workboo. Do you want to updat
this workbook with changes made to the other workbook? To
update all linked information, click Yes. To keep the
existing information, click No.

To what workbook is it linked? If I click Yes, it gives me
a 'File Not Found' message with a browse window. If I say
no then the box goes away.

How can I make it so that this dialog box doesn't even
come up? Can we dis-associate the link programmatically in
code before it is sent?

Thank you in advance
God bless you

-----Original Message-----
Hi andy

Try CDO to send Mail
You can fill in your SMTP server in the code

See the CDO link on this page
http://www.rondebruin.nl/sendmail.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"andy" <[email protected]> wrote in

message news:[email protected]...

 

[Ron de Bruin]

Hi andy

You workbook must have a link to a other workbook
Use this Add-in to find all your links in that workbook.

<findlink.zip>

On this site http://www.bmsltd.ie/MVP/

 

[andy]

Greetings Ron,

You have been extreamly helpful to me. Thank you very
much for being willing to share your expertise. I thank
God that there are persons such as yourself willing to
spend time, energy, and knowledge with others.

I downloaded the FindLink.zip, and ran it against the
file. It found no links, and so I used the other options
to search for broken links by using #REF, and still no
success. I do have a sheet (hidden) within this same
workbook (.xls) file which I use as values for the combo
boxes on the main form. However I never got this message
until I put into place the code for the CDO to send mail.

Is it referring to a link to the temporary file which is
written to by the code? Please let me know if there is
anything else I can try.

God bless you

 

[Ron de Bruin]

Hi Andy

Send me the workbook and I take a look at it for you if you want.