Show Bid Request Excel Macro Bid Request Id: 13824 Bookmark in my 'To Do' list Posted by: LMW (2 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 0.00% Buyer Security Verifications: Unverified Approved on: Apr 17, 2002 7:48:10 PM EDT Bidding Closes: Apr 19, 2002 8:06:02 PM EDT Viewed (by coders): 170 times Deadline: 4/20/2002 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Question or Beginner / Newbie Assistance Bidding Type: Open Auction Categories: Windows, Visual Basic Enter chat room for this bid request (0 active users at Sep 29, 2003 2:43:39 AM EDT) Description: I use Excel 2000 a lot and I'm working on automating a workbook lets say cell C4 is used for "building location" and the user enters ABG (a building location) and I store the email address of each location in lets say Z1:Z10. I want the macro to insert the correct email recipient address for the location enter in C4 in the following ThisFile = Range("A1").Text ActiveWorkbook.SaveAs Filename:="C:\Test\" & ThisFile, FileFormat:=xlNormal ActiveWorkbook.SendMail "recipients address", "Subject of message goes here" Deliverables: Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. Platform: Windows 98 xp 2000 Must be 100% finished and received by buyer on: Apr 20, 2002 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! Odyssey (27 ratings) in Bangalore, Karnataka India Bid id: 151,999   $20 (USD) Apr 17, 2002 8:16:17 PM EDT  9 (Superb)     Hi, Here is my bid for your new Macro... Let me know if you need any change in Bid Amount. Regards, Odyssey           There are 5 private replies to/from Odyssey. Click here to view them.