Programming Tools
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Programming > Programming Tools
Reload this Page

MS Excel: Exporting columns as csv then send as email.

Discuss MS Excel: Exporting columns as csv then send as email. in the Programming Tools forum on Dev Articles.
MS Excel: Exporting columns as csv then send as email. Programming Tools forum for discussing any topics that don't fit into the programming categories above. Find information on tools and utilities to increase any programmer's productivity.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old July 30th, 2003, 09:25 AM
worchyld worchyld is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jul 2003
Posts: 13 worchyld User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
MS Excel: Exporting columns as csv then send as email.
On our customer's excel sheet I would like to have a button that says "[Send to Sales]" and this will save the three columns of their excel sheet (First name, last name, email address) to a csv file then email it to us.

Is this possible in Excel/VBA?
Reply With Quote
  #2  
Old July 30th, 2003, 10:50 AM
digitallysmooth digitallysmooth is offline
you know how we do
Dev Articles Novice (500 - 999 posts)
  
Join Date: Jun 2002
Posts: 788 digitallysmooth User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 34 m 21 sec
Reputation Power: 7
Quote:
Is this possible in Excel/VBA?
YES, it is not all that tough. I will try to find the code I used to do something similar and post it for you.
__________________
__________________________________________________ _
Wil Moore III, MCP | Integrations Specialist | Senior Consultant
Are You Listed...? | DigitallySmooth Inc.
Reply With Quote
  #3  
Old July 31st, 2003, 02:31 AM
worchyld worchyld is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jul 2003
Posts: 13 worchyld User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thanks - I should make clear that our customers will receive the excel sheet with "First name, surname, email, postal address...etc" but when they press a button it should just export "First name, surname and email" to a csv file then email it to us.

Thanks again.
Reply With Quote
  #4  
Old February 20th, 2004, 01:02 AM
sengkangboy sengkangboy is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Feb 2004
Posts: 1 sengkangboy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Hi,

May i know how you do it. I also require a simliar app where i can send an email to a list of customers with certain data in a xls.

You can email directly to me at andy.z.chan@motorola.com
Regards,


Quote:
Originally Posted by worchyld
Thanks - I should make clear that our customers will receive the excel sheet with "First name, surname, email, postal address...etc" but when they press a button it should just export "First name, surname and email" to a csv file then email it to us.

Thanks again.
Reply With Quote
  #5  
Old January 10th, 2005, 10:26 AM
rockjock927 rockjock927 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jan 2005
Posts: 1 rockjock927 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
CSV Export
Would you be so kind as to forward a copy to me? It would be of great use.
Thanks,
Malcolm
Reply With Quote
  #6  
Old March 21st, 2005, 09:53 AM
zakihj zakihj is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Mar 2005
Posts: 1 zakihj User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 m 32 sec
Reputation Power: 0
code
I would like to know if you found the code for your question.

Thank you

Hani Zaki

Quote:
Originally Posted by worchyld
On our customer's excel sheet I would like to have a button that says "[Send to Sales]" and this will save the three columns of their excel sheet (First name, last name, email address) to a csv file then email it to us.

Is this possible in Excel/VBA?
Reply With Quote
  #7  
Old June 15th, 2005, 11:41 AM
Shame Shame is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Mar 2005
Posts: 5 Shame User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 41 m 7 sec
Reputation Power: 0
Mail code for VB in Excel
Application.Dialogs(xlDialogSendMail).Show ("Mail Group name")

The only requirements with this is that your mail server is open and the recipients are in a mail group. Hope this helps.
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Programming > Programming Tools > MS Excel: Exporting columns as csv then send as email.

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway. 
Stay green...Green IT