vba to send email attachment

[Magicman]

Hey, I'm kinda new to vba and was wonderying if anyone could help with
my code. I want this template I created automatically sent through
email and have it titled (subject) as a cell in the worksheet. I
found some code to send email but it was a little different than what
I want to do. If anyone can help point me in the right direction
please let me know thanks!

 

[ward376]

What email client are you using? Maybe something like:
Dim sJect As String
sJect = yoursheet.Range("a1").text

Cliff Edwards

 

[PCLIVE]

If you haven't already, check out Ron de Bruin's site.

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

HTH,
Paul

 

[Magicman]

If you haven't already, check out Ron de Bruin's site.

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

HTH,
Paul

--






- Show quoted text -

I am using microsoft outlook, I will check out the site thanks.

 

[Magicman]

I am using microsoft outlook, I will check out the site thanks.- Hide quoted text -

- Show quoted text -

I got it to send the attachment but am having problems with sending to
more than one person and getting the subject to display a cell in the
sheet?

 

[Ron de Bruin]

Click on the Tip link on each page

For Outlook this one
http://www.rondebruin.nl/mail/tips2.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

I am using microsoft outlook, I will check out the site thanks.- Hide quoted text -

- Show quoted text -

I got it to send the attachment but am having problems with sending to
more than one person and getting the subject to display a cell in the
sheet?

 

[Magicman]

Click on the Tip link on each page

For Outlook this onehttp://www.rondebruin.nl/mail/tips2.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm






I got it to send the attachment but am having problems with sending to
more than one person and getting the subject to display a cell in the
sheet?- Hide quoted text -

- Show quoted text -

Thanks a ton, works great