| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
send email with email addresses in a range of cells
I'm trying to send a workbook to a list of email addresses within the
workbook. When I use ActiveWorkbook.SendMail and list the recipients as values of cells withing the workbook, It's coming up with a 1004, unkown recipient name in list of recipients. How would i format the recipient section in the vb code to get rid of this error? Or is there a better way to do this all together (other than ActiveWorkbook.SendMail? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to merge email addresses in excel with a document and send it? | Excel Discussion (Misc queries) | |||
| Send different worksheets to different email addresses | Excel Discussion (Misc queries) | |||
| Macro to send email to multiple addresses | Excel Worksheet Functions | |||
| Can I send a doc to group of email addresses via a macro button? | Excel Discussion (Misc queries) | |||
| Trying to send an email with body text, to a range of cells | Excel Discussion (Misc queries) | |||
![Craig[_24_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
