outlook subject from excel cell


R

rslc

Hi
I can populate outlook 2003 subject line with vba ie,
Subject:=Range("C2") & Format(Date, " dd/mmm/yy") which displays contents
of C2 and the current date. However i would also like to add contents of
cell F2 as well ie "C2 space F2 space Date" but am having trouble finding
the exact code to accomplish this, any help much appreciated.


thanks

rslc
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top