error with Formulas when transposing ito single cell

Hi,

please see attached my sheet as an example

The Code I am using to transpose all the data from column "C" gives me an error when it encounters the "N/A" .

help??

Try this, it will ignore any error formulas:

Please Login or Register  to view this content.

Originally Posted by sonny.thind

Can I add an Input box for inputing the ID # data into column "B" (each ID #seperated by commas)?

Yes, I suppose you can add an input box for any purpose you want.

is it possible to copy the output cell and automatically sending it to outlook?

Sure, 1000s of examples on this forum and via Google. One small example:

Please Login or Register  to view this content.

Ok So I found a Macro to send the emails --however I still have to click the 'Check Name' tab in outlook to validate the addresses from my exchange server.
how do I add this to the macro to do it for me?
here is the code..

Please Login or Register  to view this content.

I was wondering if I need to start a new thread for this issue as this is not relevant to the original thread. i just need to know how to add the resolve all on the above macro

Ok So I found a Macro to send the emails --however I still have to click the 'Check Name' tab in outlook to validate the addresses from my exchange server.
how do I add this to the macro to do it for me?
here is the code..

Please Login or Register  to view this content.

Sub Mail()
Dim OutlookApp As Object
Dim Mess As Object, Recip
Recip = Range("E8")
Set OutlookApp = CreateObject("Outlook.Application")
Set Mess = OutlookApp.CreateItem(olMailItem)
With Mess
.Subject = "Subject"
.Body = "Body"
.To = Recip
.Display
End With

End Sub

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[/CODE]