Anant Chirmade
New Member
Hi Team,
I have a automated report which published on email using "RangetoHTML" function..
Part of the email code is :
When the email is sent, Snapshot for "RangetoHTML(rng)" is displayed twice.
1st at the proper place and 2nd at the very end of the email,which is unnecessary.
Rng1 and Rng2 snapshots are placed on proper place..
only Rng is repeated.
Please help..
Thanks in Advance.
I have a automated report which published on email using "RangetoHTML" function..
Part of the email code is :
Code:
.HTMLBody = Body1 & RangetoHTML(rng) & Body2 & RangetoHTML(rng1) & Body3 & RangetoHTML(rng2)
When the email is sent, Snapshot for "RangetoHTML(rng)" is displayed twice.
1st at the proper place and 2nd at the very end of the email,which is unnecessary.
Rng1 and Rng2 snapshots are placed on proper place..
only Rng is repeated.
Please help..
Thanks in Advance.