I have an excel file. This file has 4 columns - sign, first name, last name and Email.
My goal is to create a button on each line (or link) that will automatically create an email using the email address in that record. Not only will it say Dear first name and last name, but it will also have a word document attached. This word document will automatically generate with the sign number and save itself as sign###.doc. (# = number in the sign field) The email will then open in outlook with: the subject of - "Testing 123" the body of - "Dear Firstname and last name," attachment of - "Sign###.doc" . Does anybody know if this is possible? If so, what is the code that i need to use. Also, I am not a VB expert, but I know my way around macros and excel. THANKS IN ADVANCE! --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
