ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sending workbook/sheet to recipient list (https://www.excelbanter.com/excel-discussion-misc-queries/184000-sending-workbook-sheet-recipient-list.html)

jatman

sending workbook/sheet to recipient list
 
good afternoon,

using Vista w/ Office 2007.

i have a worksheet (count) that i want to email to whose email addresses are
in Sheet2 Column A.

without the addin, can a small macro do this, or will it be a larger macro?
or can an recipient array be used to look up the emails on the second sheet?

thank you,

jat

JP[_4_]

sending workbook/sheet to recipient list
 
Have you checked this site for relevant code?

http://www.rondebruin.nl/sendmail.htm


HTH,
JP

On Apr 16, 7:29*pm, jatman wrote:
good afternoon,

using Vista w/ Office 2007.

i have a worksheet (count) that i want to email to whose email addresses are
in Sheet2 Column A.

without the addin, can a small macro do this, or will it be a larger macro?
or can an recipient array be used to look up the emails on the second sheet?

thank you,

jat




All times are GMT +1. The time now is 04:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com