|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
March 16th 09, 11:46 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Send email using spreadsheet
No problem, and good luck to you!
On Mar 15, 10:12*am, atwork wrote: JP, I will make those changes but I just wanted to say thanks for the excellent help!! "JP" wrote: You'll want to change Dim olNs Dim olMail to Dim olNs As Outlook.Namespace Dim olMail As Outlook.MailItem It doesn't look like you're using the variable Email_Address anywhere in your procedure, so I think you can safely remove it. And you haven't declared variable i. Overall it looks correct, but you've hardcoded the loop counter. When you add or remove email addresses from column A, you'll need to revise the loop. --JP 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Check boxes in spreadsheet not lined-up when sent in email | bmnjna2019 | Outlook - Using Forms | 1 | October 29th 08 01:43 PM |
| need to send e-mail to addresses listed in spreadsheet | cinnie | Outlook - Using Contacts | 1 | August 14th 07 09:04 PM |
| Using email addresses from an Excel spreadsheet? | Jan | Outlook Express | 3 | October 4th 06 01:37 PM |
| Sending email from source Excel spreadsheet | Richard Edwards | Outlook - General Queries | 1 | August 9th 06 07:15 PM |
| How can I send a spreadsheet with email? | Dr.Jon | Outlook - Installation | 4 | June 29th 06 12:09 AM |
Hybrid Mode
