Hi,

im trying to automatically email a spreadsheet. i'm hoping to include this
in a macro.

i'd like to email the sheet i create to an email address which is provided
on the sheet through a Vlookup from a contact list.. (if that makes sense!?).


is it possible to automatically send this via Microsoft outlook without
starting a whole new message and having to type in the email address and
search for the attachment? - if so is it possible to include this in a macro?

Hi John

Ron de Bruin has a whole series of code examples on how to deal with any
aspect of sending email attachments.
http://www.rondebruin.nl/sendmail.htm

--

Regards
Roger Govier

"JohnEFC" wrote in message
...
Hi,

im trying to automatically email a spreadsheet. i'm hoping to include
this
in a macro.

i'd like to email the sheet i create to an email address which is provided
on the sheet through a Vlookup from a contact list.. (if that makes
sense!?).


is it possible to automatically send this via Microsoft outlook without
starting a whole new message and having to type in the email address and
search for the attachment? - if so is it possible to include this in a
macro?

JohnEFC wrote:
Hi,

im trying to automatically email a spreadsheet. i'm hoping to include this
in a macro.

i'd like to email the sheet i create to an email address which is provided
on the sheet through a Vlookup from a contact list.. (if that makes sense!?).

is it possible to automatically send this via Microsoft outlook without
starting a whole new message and having to type in the email address and
search for the attachment? - if so is it possible to include this in a macro?


Check on the web for RON DE BRUIN he has helped me a lot with this type of
thing.

(and he also watches this forum...so you may get a more direct reply)

--
Message posted via http://www.officekb.com

Thanks for the help guys

"Francois via OfficeKB.com" wrote:

JohnEFC wrote:
Hi,

im trying to automatically email a spreadsheet. i'm hoping to include this
in a macro.

i'd like to email the sheet i create to an email address which is provided
on the sheet through a Vlookup from a contact list.. (if that makes sense!?).

is it possible to automatically send this via Microsoft outlook without
starting a whole new message and having to type in the email address and
search for the attachment? - if so is it possible to include this in a macro?


Check on the web for RON DE BRUIN he has helped me a lot with this type of
thing.

(and he also watches this forum...so you may get a more direct reply)

--
Message posted via http://www.officekb.com

Ive been to the site and found exactly what im looking for.

just a small side issue..

in the vb text to lookup the email address on my work sheet the below is used

For Each sh In ThisWorkbook.Worksheets
If sh.Range("A1").Value Like "?*@?*.?*" Then

so presumably this means this will search and use email addresses such as
?

however a lot of contacts i use have more "dots" in their addresses. for
example

how do i include this in the vb text to pick up Value Like "?*@?*.?*" AND
"?*.?*@?*.?*" AND ALSO "?*.?*@?*.?*.?*"

Any help would be appreciated, i hope ive explained clearly.



"Roger Govier" wrote:

Hi John

Ron de Bruin has a whole series of code examples on how to deal with any
aspect of sending email attachments.
http://www.rondebruin.nl/sendmail.htm

--

Regards
Roger Govier

"JohnEFC" wrote in message
...
Hi,

im trying to automatically email a spreadsheet. i'm hoping to include
this
in a macro.

i'd like to email the sheet i create to an email address which is provided
on the sheet through a Vlookup from a contact list.. (if that makes
sense!?).


is it possible to automatically send this via Microsoft outlook without
starting a whole new message and having to type in the email address and
search for the attachment? - if so is it possible to include this in a
macro?

Hi John

Is working also for your addresses




--

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


"JohnEFC" wrote in message ...
Ive been to the site and found exactly what im looking for.

just a small side issue..

in the vb text to lookup the email address on my work sheet the below is used

For Each sh In ThisWorkbook.Worksheets
If sh.Range("A1").Value Like "?*@?*.?*" Then

so presumably this means this will search and use email addresses such as
?

however a lot of contacts i use have more "dots" in their addresses. for
example

how do i include this in the vb text to pick up Value Like "?*@?*.?*" AND
"?*.?*@?*.?*" AND ALSO "?*.?*@?*.?*.?*"

Any help would be appreciated, i hope ive explained clearly.



"Roger Govier" wrote:

Hi John

Ron de Bruin has a whole series of code examples on how to deal with any
aspect of sending email attachments.
http://www.rondebruin.nl/sendmail.htm

--

Regards
Roger Govier

"JohnEFC" wrote in message
...
Hi,

im trying to automatically email a spreadsheet. i'm hoping to include
this
in a macro.

i'd like to email the sheet i create to an email address which is provided
on the sheet through a Vlookup from a contact list.. (if that makes
sense!?).


is it possible to automatically send this via Microsoft outlook without
starting a whole new message and having to type in the email address and
search for the attachment? - if so is it possible to include this in a
macro?