#1   Report Post  
Aaron
 
Posts: n/a
Default excel to outlook

Good afternoon,

Is it unheard of to use a spreadsheet to, in a way, merge to an email.

meaning, if I have a generic bodied letter, and a spreadsheet the lists
email address, can I send this data to outlook and send an email per row in
my spreadsheet?

Any direction will help

thanks
aaron
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

It'd probably take some work in Excel, where Word has functionality to handle
this rather quickly & easily. Crank up Word, display the Mailmerge toolbar,
set up your form document, and merge in the data from the Excel file. You'll
then have the option (one of the buttons on the toolbar) to Mailmerge to email

"Aaron" wrote:

Good afternoon,

Is it unheard of to use a spreadsheet to, in a way, merge to an email.

meaning, if I have a generic bodied letter, and a spreadsheet the lists
email address, can I send this data to outlook and send an email per row in
my spreadsheet?

Any direction will help

thanks
aaron

  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

I would start with the basics. Ron de Bruin has some
basic code for manipulating Outlook via Excel:

http://www.rondebruin.nl/sendmail.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
Good afternoon,

Is it unheard of to use a spreadsheet to, in a way,

merge to an email.

meaning, if I have a generic bodied letter, and a

spreadsheet the lists
email address, can I send this data to outlook and send

an email per row in
my spreadsheet?

Any direction will help

thanks
aaron
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i export a Excel database a Outlook address book? Ash Excel Discussion (Misc queries) 2 February 8th 05 05:19 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
I want to do mass mailing in outlook, from an excel file that has. Franco Excel Discussion (Misc queries) 2 January 25th 05 07:49 AM
Excel Exits on File Close with Outlook Erin Searfoss Excel Discussion (Misc queries) 1 January 16th 05 09:43 PM
VB Automation is Whacking out my Excel Environment Joseph Geretz Excel Discussion (Misc queries) 2 December 29th 04 03:49 PM


All times are GMT +1. The time now is 09:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"