Thread: vba to send multiple workbooks to different address
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
jamesc jamesc is offline
external usenet poster
  
Posts: 16
Default vba to send multiple workbooks to different address
hi everyone,

I have 80 workbooks in one folder. i'd like to be able to find a way to
automate opening each workbook, finding an email address in a1 and create
and send an email. i'd like for this to cycle through every workbook in the
folder. any ideas?

Thanks in advance!

James


Reply With QuoteReply With Quote