[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Send email from Microsoft Excel worksheet

Posted on 2014-03-08
3
Medium Priority
?
535 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 28

Accepted Solution

by:
MacroShadow earned 1500 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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

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

As a matter of fact, Outlook OST files are of much importance in relation to Exchange mailbox. OST files are independent as they are simply copy of data of a user’s mailbox on Exchange Server. Though, if the server’s status is changed or it is dama…
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Suggested Courses

590 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