Dynamic field by macro

[#1]

Dear All,

I want to send a mail through macro which has been done but in mail body i want to put Dealer name and their area office at top .

Consider the below format

Dealer Name,Area Office(Should be change according to dealer)

Dear Sir/Mam,

  Please find your attached Crusade performance for the month of Feb-2016(Must be change on month basis).For any queries or support in improvement, please get in touch with your area office team.

[marcus_sommer]

In general something like this should work:

varPeriode = month(now()) & "-" & year(now())

varBody1 = "Dealer Name,Area Office(Should be change according to dealer) Dear Sir/Mam, Please find your attached Crusade performance for the month of  "

varBody2 = ".For any queries or support in improvement, please get in touch with your area office team."

varBodyComplete = varBody1 & varPeriode & varBody2

You might need some further adjustments to format the period differently (and/or to fetch this from a gui-variable) or to put linebreaks - Chr(10) - within the text.

- Marcus

[#3]

Hi Rasool,

             First you have to go to settings--user preferences -- mail--give the sender and server details and then go to tools -- alerts--give the details like message which you want to send it and mail recipients etc details.

[#4]

thanx for the response will check you and confirm for the same