Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,560
Default Email a statement

I have to info below in a table format- I want to email the data specific to
one email address in one mail (mail merge) and then send the 2nd person
automatically his statement- is there a way of doing this in excell
i.e "a" gets inv 800 to 803, "b" get 804 to 810

email Inv No Amount

800 200
801 300
802 400
803 500
804 600
805 700
806 800
807 900
808 1000
809 1100
810 1200



--
Thanks for your help
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Email a statement

hi David

See this for a Outlook Body mail
http://www.rondebruin.nl/mail/folder3/row2.htm

There is also a attachment example on my site


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"David" wrote in message ...
I have to info below in a table format- I want to email the data specific to
one email address in one mail (mail merge) and then send the 2nd person
automatically his statement- is there a way of doing this in excell
i.e "a" gets inv 800 to 803, "b" get 804 to 810

email Inv No Amount

800 200
801 300
802 400
803 500
804 600
805 700
806 800
807 900
808 1000
809 1100
810 1200



--
Thanks for your help

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
Using Macro how to create email link for the email addresses in aRange or Selection Satish[_2_] Excel Worksheet Functions 8 December 28th 09 03:30 PM
how do i send an automated email from excel using an if statement Daniel Excel Worksheet Functions 0 August 5th 08 11:07 AM
Excel VBA macro to send email attachment from default email client wifigoo Excel Programming 2 April 12th 08 03:54 PM
Email help...need IF statement for more than one recipient tanyhart[_28_] Excel Programming 3 June 28th 06 03:22 PM
If statement to send email Michael McClellan Excel Programming 3 June 11th 04 09:32 PM


All times are GMT +1. The time now is 08:10 PM.

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

About Us

"It's about Microsoft Excel"