|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: attach, automate, email, excel, workbook, worksheet |
|
|
Thread Tools | Display Modes |
|
#1
April 12th 07, 05:07 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Automate email and attach excel worksheet or workbook
I'm trying to create a macro in Outlook that will send an email with
an excel attachment. I have a list of different excel files and each file needs to go to a specific person. i.e. To: Joe Smith Attachment: Joe Smith.xls and so on. Is this possible? 
|
| Ads |
|
#2
April 12th 07, 06:37 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Automate email and attach excel worksheet or workbook
Simply create one MailItem per recipient with the CreateItem function, then use Recipients.Add and Attachments.Add. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Quick-Cats - The most effective way to assign Outlook categories: http://www.shareit.com/product.html?...4&languageid=1 (German: http://www.VBOffice.net/product.html?pub=6) Am 11 Apr 2007 20:07:32 -0700 schrieb wilma2299: I'm trying to create a macro in Outlook that will send an email with an excel attachment. I have a list of different excel files and each file needs to go to a specific person. i.e. To: Joe Smith Attachment: Joe Smith.xls and so on. Is this possible?
|
|
#3
April 12th 07, 01:44 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Automate email and attach excel worksheet or workbook
Thank you for the quick response. I was hoping to create a generic
macro that would do everything and not have to go through and create a macro for each person.
|
|
#4
April 13th 07, 07:06 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Automate email and attach excel worksheet or workbook
That's what I told you :-) One macro can create as many items as you like. And you would need one for each recipient if everyone should receive different attachments. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Quick-Cats - The most effective way to assign Outlook categories: http://www.shareit.com/product.html?...4&languageid=1 (German: http://www.VBOffice.net/product.html?pub=6) Am 12 Apr 2007 04:44:28 -0700 schrieb wilma2299: Thank you for the quick response. I was hoping to create a generic macro that would do everything and not have to go through and create a macro for each person.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Automatically trust embedded Excel worksheet in form? | NW_DE | Outlook - Using Forms | 0 | March 28th 07 01:12 AM |
| How can I eMail only the selection from Excel, not the workbook | Andre | Outlook - General Queries | 0 | February 20th 07 08:46 PM |
| Outlook contacts list into Excel worksheet? | Ed | Outlook and VBA | 3 | February 2nd 07 12:33 AM |
| Directly connected Excel worksheet for an Access Form | JAI | Outlook - Using Contacts | 0 | October 19th 06 01:27 PM |
| Hyperlinking from Outlook 2003 to an excel Worksheet | fidgitthedigit | Outlook - General Queries | 2 | May 5th 06 05:32 PM |
Linear Mode
