need a macro to send emails

12 views
Skip to first unread message

My Excel

unread,
May 28, 2016, 2:55:37 AM5/28/16
to Excel VBA Lab - An Excel VBA Macro help Group
Hi Expert's,

need a macro to send emails using excel ( send only)
i am using outlook 2007 in my sys
i send/received mail this sys
next to this sys. there is a another sys of my colleague he also want send emails
problem is email id is only 1, his work is only sending emails to 8 email ids (single/multi)
outlook installed in my sys. only he don't need download/receive emails

pls help


Thanks in Advance

V

Vaibhav Joshi

unread,
May 30, 2016, 2:24:11 AM5/30/16
to Excel VBA Lab
hi

which operating system you are using?

which mail services you will be using like gmail etc



--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab - An Excel VBA Macro help Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at https://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/06c6ea76-b946-45d6-ac02-6aae064d645d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

My Excel

unread,
May 30, 2016, 4:55:16 AM5/30/16
to Excel VBA Lab - An Excel VBA Macro help Group
windows 7 - 64bit

our office mail (private mail ) not gmail

outlook 2007 installed by our senior


Vaibhav Joshi

unread,
May 30, 2016, 7:39:52 AM5/30/16
to Excel VBA Lab
not sure, you can try as below:

in outlook configuration do not give credential for POP server, so you wont be able to receive any email on that machine..

you need to provide only smtp server details to send email from that machine.

My Excel

unread,
May 30, 2016, 10:09:13 AM5/30/16
to Excel VBA Lab - An Excel VBA Macro help Group
Reply all
Reply to author
Forward
0 new messages