Using Excel 2007 to Prepare an Email in Outlook 2007 in a customized format.

[rahulin]

Hi

I am a new user to this board and I must say I am really thankful to what all help I've been able to receive from this website in order to learn and understand how Excel Macro's work.

I am trying to create a Macro, which can actually retrieve data from Hyperion Essbase system for my retrieve template (already completed this Macro).

Second Part:

Now I am working on creating this Macro to create an email using Outlook which will have the message as below:

-------------------------------------------------------------------------
Hi,

Please find the link to Jul-10 file for 06-08-10 for Group 1 :

link to the file:

"D:\Documents and Settings\admin\Desktop\New.xlsx"


Total = $ Debit 409k

1. Random 1 = $ Credit 50k (Need to check with Dept)
2. Random 4 = $ Credit 60k (Genuine)

a. Random 2 = $ Credit 50k (Cause Known)

b. Random 3 = $ Credit 10k (Unsure)

3. Random 5 = $ Nil
4. Random 6 = $ Credit 100k (Expected)
5. Random 7 = $ Credit 1k (Immaterial)
6. Random 8 = $ Debit 10k (Investigation pending)
7. Random 9 = $ Debit 30k (Investigation pending)
8. Random 10 = $ Debit 550k (Investigation pending)
9. Random 11 = $ Debit 30k (Investigation pending)


Thanks and Kind regards,

Signature [Auto signature should come up]

-------------------------------------------------------------------------

The format is really critical, it has to have the format as stated above only and no change.



The numbers for each item gets populated from Column 'H' in the attached excel file, the Debits needs to appear in Red (Bold) and Credits in Green, the comment section in the attached file (Column BX) comes after each line in brackets in Black (Bold color only) as shown on the above format.

I am struggling with the formatting section when trying to code, any help would be useful.

Thanks and Kind regards

Rahul

Please Login or Register  to view this content.