vba to send email attachment
 

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!

vba to send email attachment
 

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

Cliff Edwards

vba to send email attachment
 

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

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

HTH,
Paul

--

"Magicman" wrote in message
...
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!

vba to send email attachment
 

On Mar 28, 11:24*am, "PCLIVE" wrote:
If you haven't already, check out Ron de Bruin's site.

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

HTH,
Paul

--

"Magicman" wrote in message

...



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!- Hide quoted text -

- Show quoted text -

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

vba to send email attachment
 

On Mar 28, 11:36*am, Magicman
wrote:
On Mar 28, 11:24*am, "PCLIVE" wrote:





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

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

HTH,
Paul

--

"Magicman" wrote in message

...

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!- Hide quoted text -

- Show quoted text -

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?

vba to send email attachment
 

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


"Magicman" wrote in message
...
On Mar 28, 11:36 am, Magicman
wrote:
On Mar 28, 11:24 am, "PCLIVE" wrote:





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

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

HTH,
Paul

--

"Magicman" wrote in message

...

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!- Hide quoted text -

- Show quoted text -

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?

vba to send email attachment
 

On Mar 28, 12:26*pm, "Ron de Bruin" wrote:
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

"Magicman" wrote in message

...
On Mar 28, 11:36 am, Magicman
wrote:





On Mar 28, 11:24 am, "PCLIVE" wrote:

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

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

HTH,
Paul

--

"Magicman" wrote in message

....

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!- Hide quoted text -

- Show quoted text -

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?- Hide quoted text -

- Show quoted text -

Thanks a ton, works great