Macro: Excel mail attachment - celle-value as Subject of mail

[Snoopy]

Hey fellows!

Here is my problem:
I have made a macro to copy a range - (A1:K15) - into an attachment of
an outgoing mail.
Can anyone guide me how to make the celle-content of one info-celle
(ex: celle A16) appear as "Subject" of this mail?

Kindly regards Snoopy

 

[Franz Verga]

Nel post:[email protected],

Hey fellows!

Here is my problem:
I have made a macro to copy a range - (A1:K15) - into an attachment of
an outgoing mail.
Can anyone guide me how to make the celle-content of one info-celle
(ex: celle A16) appear as "Subject" of this mail?

Kindly regards Snoopy

Hi Snoopy,

to send e-mail from Excel, the best resource of the web is Ron de Bruin's
site:

http://www.rondebruin.nl/sendmail.htm


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.


Thanks in advance for your feedback.


Ciao


Franz Verga from Italy

 

[Snoopy]

Nel post:[email protected],




Hi Snoopy,

to send e-mail from Excel, the best resource of the web is Ron de Bruin's
site:

http://www.rondebruin.nl/sendmail.htm

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Thanks Franz, I'm looking through the tips now - and proberbly take
contact with mr Ron de Bruin