Thread: macro tweaking
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jatman jatman is offline
external usenet poster
 
Posts: 88
Default macro tweaking

good afternoon,

i have most of my macro written (Office 2007,) but am having a small issue
with the following line:

'Sub Email() - sends a copy of the email to the recipients
ActiveWorkbook.SendMail "
'End Sub Email()

i cannot get more than one email address into the recipients list without
getting some sort of an error. how would i add more than one recipient to
the list. i have tried commas, semi-colons, and the "&" symbol between the
email addresses.

any other suggestions?

thank you,

jat