Insert Current month into body of email

[cheeze83]

Hi everyone

I am currently using a VBA from Ron de Bruin to send a worksheet via email, which is working fine. However, if I can I want to add the current month (when the email is sent) to the body of the email. Below is the code I have, and where it says [MONTH] that's where I need the month to go. I have tried "Please find attached " & Format(Now, "mmm-yy") "rest of message....."

but this didn't work. Had an error saying expected end of line or something like that. Any help will be greatly appreciated!

Please Login or Register  to view this content.

[Fotis1991]

Welcome to the forum

Pls

Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future

[cheeze83]

Many thanks - apologies, I registered originally a while ago but first post, will go an re-familiarise myself with the guides and rules again. Many thanks

[Fotis1991]

That's why we are here! To show the correct road!

Your understabding is much appreciated!

Good luck with your thread!

[cheeze83]

I've actually managed to solve this problem, and thought would post in-case someone else has similar issue.

The problem was I was typing

Please Login or Register  to view this content.

Where as I should have been typing

Please Login or Register  to view this content.

[Fotis1991]

That's great. We thank you for posting the solution as maybe will helps someone else as you said.

So in this case, pls.

Please mark your Thread as SOLVED. Select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.

[cheeze83]

Done =) Thanks for your assistance

That's great. We thank you for posting the solution as maybe will helps someone else as you said.

So in this case, pls.

Please mark your Thread as SOLVED. Select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.