Hi Guys,
I have about 400 people in an excel file and I have to send them an e-mail containing two unique pdf. Is it possible to fix this through excel and outlook (or some other e-mail client).
Take a look at my example.
Thanks in advance
Hi Guys,
I have about 400 people in an excel file and I have to send them an e-mail containing two unique pdf. Is it possible to fix this through excel and outlook (or some other e-mail client).
Take a look at my example.
Thanks in advance
Last edited by cyberelf77; 05-22-2013 at 09:52 AM.
Nothing more than a modification to Ron De Bruin's method - all credit given.
I would likely changetoPlease Login or Register to view this content.
as you are testing to ensure that you are happy with the process/results/content.Please Login or Register to view this content.
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Thanks for your fast reply.
I have tried to modify it, but it seems to ignore the first attachment, When I hit run then it opens an outlook window with attachment #2... But hey, I'm a total newbie when it comes to this.
Cheers.
omg... my bad. It's fixed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks