Belair58
Board Regular
- Joined
- Mar 31, 2005
- Messages
- 95
Hi,
I'm using the e-mail function from Lotus Notes (Thanks for the code) but I a couple of users that are still using 97 and the code blows up at the following command.
To be exact, right at the Join command. Is there code I could use to accomplish this same task without using the Join command?
As always your help is greatly appreciated.
Thanks
I'm using the e-mail function from Lotus Notes (Thanks for the code) but I a couple of users that are still using 97 and the code blows up at the following command.
Code:
MailDoc.Body = _
Replace("The following NEW SUPPLIER request had been actioned today:@@" _
& Join(Application.Transpose(Range([a1], [a300].End(3))), "@") _
& "@@...", "@", vbCrLf)
As always your help is greatly appreciated.
Thanks