Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default Sending a Mail from outlook with body coming from excel file

Hi all,

I have made a outlookproject that sends templated mail from a excel workbook.
this follows the teachings from Ron de Bruin.

the thing is his tutorial is to send the email from excel, and i whant tho send the mail from outlook.
I guess I have to create a excel object copy the range and than use his code the "RangetoHTML function"

can someone help me?
I thank in advance
  #2   Report Post  
Junior Member
 
Posts: 2
Default

I have partialy soved the problem by viewing the excel file as web, than copying the source code, editing into a static templates html formated string (this was this macro´s goal.) the intention also was been able to make it a dinamic template creator, hustleless.

the help is still whanted for anyone ho dont mind donating a bit of knowloge.

best Regards,
PauloD.

Quote:
Originally Posted by PauloD View Post
Hi all,

I have made a outlookproject that sends templated mail from a excel workbook.
this follows the teachings from Ron de Bruin.

the thing is his tutorial is to send the email from excel, and i whant tho send the mail from outlook.
I guess I have to create a excel object copy the range and than use his code the "RangetoHTML function"

can someone help me?
I thank in advance

Last edited by PauloD : November 11th 10 at 02:04 PM
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 to automate excel file sending by outlook from within the file Adrian Excel Discussion (Misc queries) 1 September 12th 08 01:59 PM
sending mails from excel...but mail body disappearing Jithu Excel Discussion (Misc queries) 1 January 10th 08 01:03 PM
Excel(with hyperlinks) as a message body of outlook mail hans Excel Discussion (Misc queries) 1 July 7th 06 12:35 PM
How to make Microsoft Outlook default e-mail when sending excell . Aimee Excel Discussion (Misc queries) 1 March 4th 05 05:19 PM
When sending file via email, cannot paste Excel data into body of letter. Pierre Excel Discussion (Misc queries) 2 February 23rd 05 09:27 PM


All times are GMT +1. The time now is 03:23 AM.

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

About Us

"It's about Microsoft Excel"