VBA code for Outlook sending mails

[Supriya]

Hi,

I have data of 10 cities with respective managers.

I just want to send the emails to them with the excel dashboard & fixed body messages in mail body copy.

Their are two excel dashboard on different sheets. While sending mail just forwarding both dathboard citywise to respective manager.

pl help for VBA Coding.


Regards,

Supriya.

 

[ThrottleWorks]

Hi Supriya,


Meanwhile someone helps you, could you please check the below link.


http://chandoo.org/wp/2012/04/23/send-mails-using-excel-vba-and-outlook/

 

[Supriya]

Hi ThrottleWorks,


Thanks for the help.

I already have that link but it does not help to solve my problem.


Regards,

Supriya.

 

[bobhc]

Good day Supriya


This is one of the best sites for emailing from excel


http://www.rondebruin.nl/win/section1.htm

 

[Supriya]

Hi bobhc,


Thank you very much


supriya.

 

[BoBzi]

Hi,

I have the Code (attached) to send email from excel via outlook.
i have 2 outlook accounts, Exchange and POP.
The default account is set to POP. However, from excel, the emails being sent from the exchange account.
how can i force excel to send the emails from the POP (default) account.

Thank you.

 

[SirJB7]

@BoBzi
Hi!

Would you please start a new topic instead of writing on another user's one? It might be seen as hijacking. More indeed when it's such and old topic. If needed you could add a reference in your new one.

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you.

Regards!

PS: Please don't answer here at this thread.