Thread: Help with Creating Email

I have an excel 2003 workbook in which sheet A contains a report that needs
to be emailed on a regular basis. I would like to do this in VBA, but am
unfamiliar with the syntax to use. Email needs to show as if it was sent via
Outlook 2003 (possibly showing up in sent folder of default email addy). Any
help??

Don

See Ron Debruin's site:

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

Not shown in any of his examples that I am aware is that you can send to
multiple recipients using a semicolon to concatenate the different addresses,
e.g.:

With OutMail
..To = "bob.smith@abcde.com";"bill.jones@abcde.com"
..CC = ....
etc.

Regards,
Greg


"Don" wrote:

> I have an excel 2003 workbook in which sheet A contains a report that needs
> to be emailed on a regular basis. I would like to do this in VBA, but am
> unfamiliar with the syntax to use. Email needs to show as if it was sent via
> Outlook 2003 (possibly showing up in sent folder of default email addy). Any
> help??
>
> Don
>
>
>

Thanks alot!

Don

"Greg Wilson" <GregWilson@discussions.microsoft.com> wrote in message
news:1A7DF001-6C7D-45AA-8046-F7489B22D5A7@microsoft.com...
> See Ron Debruin's site:
>
> http://www.rondebruin.nl/sendmail.htm
>
> Not shown in any of his examples that I am aware is that you can send to
> multiple recipients using a semicolon to concatenate the different
> addresses,
> e.g.:
>
> With OutMail
> .To = "bob.smith@abcde.com";"bill.jones@abcde.com"
> .CC = ....
> etc.
>
> Regards,
> Greg
>
>
> "Don" wrote:
>
>> I have an excel 2003 workbook in which sheet A contains a report that
>> needs
>> to be emailed on a regular basis. I would like to do this in VBA, but am
>> unfamiliar with the syntax to use. Email needs to show as if it was sent
>> via
>> Outlook 2003 (possibly showing up in sent folder of default email addy).
>> Any
>> help??
>>
>> Don
>>
>>
>>

>> Not shown in any of his examples that I am aware
Click on the Tip link on each example page Greg

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



"Greg Wilson" <GregWilson@discussions.microsoft.com> wrote in message news:1A7DF001-6C7D-45AA-8046-F7489B22D5A7@microsoft.com...
> See Ron Debruin's site:
>
> http://www.rondebruin.nl/sendmail.htm
>
> Not shown in any of his examples that I am aware is that you can send to
> multiple recipients using a semicolon to concatenate the different addresses,
> e.g.:
>
> With OutMail
> .To = "bob.smith@abcde.com";"bill.jones@abcde.com"
> .CC = ....
> etc.
>
> Regards,
> Greg
>
>
> "Don" wrote:
>
>> I have an excel 2003 workbook in which sheet A contains a report that needs
>> to be emailed on a regular basis. I would like to do this in VBA, but am
>> unfamiliar with the syntax to use. Email needs to show as if it was sent via
>> Outlook 2003 (possibly showing up in sent folder of default email addy). Any
>> help??
>>
>> Don
>>
>>
>>

Thank Ron not me. Correction to my post:
With OutMail
..To = "bob.smith@abcde.com;bill.jones@abcde.com"
..CC = ....
etc.

Greg


"Don" wrote:

> Thanks alot!
>
> Don
>
> "Greg Wilson" <GregWilson@discussions.microsoft.com> wrote in message
> news:1A7DF001-6C7D-45AA-8046-F7489B22D5A7@microsoft.com...
> > See Ron Debruin's site:
> >
> > http://www.rondebruin.nl/sendmail.htm
> >
> > Not shown in any of his examples that I am aware is that you can send to
> > multiple recipients using a semicolon to concatenate the different
> > addresses,
> > e.g.:
> >
> > With OutMail
> > .To = "bob.smith@abcde.com";"bill.jones@abcde.com"
> > .CC = ....
> > etc.
> >
> > Regards,
> > Greg
> >
> >
> > "Don" wrote:
> >
> >> I have an excel 2003 workbook in which sheet A contains a report that
> >> needs
> >> to be emailed on a regular basis. I would like to do this in VBA, but am
> >> unfamiliar with the syntax to use. Email needs to show as if it was sent
> >> via
> >> Outlook 2003 (possibly showing up in sent folder of default email addy).
> >> Any
> >> help??
> >>
> >> Don
> >>
> >>
> >>
>
>
>