Solved

Send email from Microsoft Excel worksheet

Posted on 2014-03-08
3
524 Views
Last Modified: 2014-03-10
Dear Experts,

We have an excel file with staff salary pay slips. Could you please suggest the easiest way to email all the pay slips to the concerned staff at once?

We use google apps for email.
If required, we can setup outlook as well.

We are using Office 2003 but can change to 2007 if that helps.

Thanks in advance

JCT
0
Comment
Question by:jct_777
3 Comments
 

Expert Comment

by:fhandley
ID: 39915537
Is this what you're looking for? (mail merge with attachments)

http://www.msoutlook.info/question/65
0
 
LVL 27

Accepted Solution

by:
MacroShadow earned 500 total points
ID: 39915560
The easiest way is using CDO.

http://www.cpearson.com/excel/Email.aspx
http://www.rondebruin.nl/win/s1/cdo.htm

If you want step by step guidance please upload a sample of your workbook (using fictitious data of course) .
0
 
LVL 1

Author Closing Comment

by:jct_777
ID: 39919573
Thanks MacroShadow. Your links helped!

JCT
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now