vba to send email attachment

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Magicman - 28 Mar 2008 16:00 GMT

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!

Reply to this Message

ward376 - 28 Mar 2008 16:05 GMT

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

Cliff Edwards

Reply to this Message

PCLIVE - 28 Mar 2008 16:24 GMT

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

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

HTH,
Paul

> 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!

Reply to this Message

Magicman - 28 Mar 2008 16:36 GMT

> If you haven't already, check out Ron de Bruin's site.
>
[quoted text clipped - 13 lines]
>
> - Show quoted text -

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

Reply to this Message

Magicman - 28 Mar 2008 17:01 GMT

On Mar 28, 11:36 am, Magicman <J...@productevaluationsystems.com>
wrote:

> > If you haven't already, check out Ron de Bruin's site.
>
[quoted text clipped - 21 lines]
>
> - 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?

Reply to this Message

Ron de Bruin - 28 Mar 2008 17:26 GMT

Click on the Tip link on each page

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

Signature

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

On Mar 28, 11:36 am, Magicman <J...@productevaluationsystems.com>
wrote:

> On Mar 28, 11:24 am, "PCLIVE" <pclive(RemoveThis)@cox.net> wrote:
>
[quoted text clipped - 23 lines]
>
> - 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?

Reply to this Message

Magicman - 28 Mar 2008 17:39 GMT

> Click on the Tip link on each page
>
[quoted text clipped - 40 lines]
>
> - Show quoted text -

Thanks a ton, works great

Reply to this Message