PDA

View Full Version : Basics of VBA in Outlook



NYBanker
05-06-2006, 11:53 AM
Hi. I'm fairly capable using VBA in Excel; but brand new to using VBA in Outlook.

I have a list of email addresses in Excel that I'd like to send the exact same email to, but send them one at a time.

I know how to open the Excel file from Outlook and read in the data, but I'm struggling with the help functions in Outlook to write the text that creates each email, populates the fields (including selecting which POP account I send the email from - I have two different POP accounts), and sends.

Is there a quick example that someone could share on this? (I've scoured the Outlook help, and haven't learned as much as I was hoping.)

Thanks!

lucas
05-06-2006, 12:58 PM
Take a look at this kb entry by geekgirlau, it uses access but it would be easy enough for you to move your excel file to a table.....works with outlook...
http://vbaexpress.com/kb/getarticle.php?kb_id=842