I am very new to using macros and I have tried to do this for a while now. Can some one help.
I am looking for a macro that will
-Open a new email
-Copy and paste data from (below) into the body
-C13 through F18
-C24 through F36
-AF24 through AK36
Any help is greatly appreciated!
Thanks!
Hello Neven,
Welcome to the Forum!
Ron De Bruin has the code and details on how to do this on his site. There are 2 ways to send emails in VBA: SendMail which uses the default email program, and Outlook.
Click here to use SendMail
Click here to use Outlook
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I have tried that site before and I always end up with a lot of errors and have no clue where to begin. I just need to see how my example is used in code so I can understand it better.
Figured it out! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks