Automatic email from Outlook of excel spreadsheet

[JohnEFC]

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?

 

[Roger Govier]

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

 

[Francois via OfficeKB.com]

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)

 

[JohnEFC]

Thanks for the help guys

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)

 

[JohnEFC]

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
(e-mail address removed)?

however a lot of contacts i use have more "dots" in their addresses. for
example (e-mail address removed)

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.

 

[Ron de Bruin]

Hi John

Is working also for your addresses