Automatic email from Outlook of excel spreadsheet

J

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?
 
F

Francois via OfficeKB.com

JohnEFC said:
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?
Click to expand...


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)
 
J

JohnEFC

Thanks for the help guys

Francois via OfficeKB.com said:
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)
Click to expand...
 
J

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
[email protected]?

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

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.
 
Top