Hi,
I am quite novice with VBA, and I am trying to figure out the syntax to make a cell's contents into a variable.
For example, here is an abridged copy of my code:
Dim emailto as string
Set emailto = *******unknown syntax for value in sheet 1 cell a1**********
Wb.Save
With EmailItem
.Subject = "Invoices and Open Balance Sheets"
.Body = "New Invoices" & vbCrLf & _
.To = emailto
.Importance = olImportanceNormal
.Attachments.Add Wb.FullName
.Send
End With
I am quite novice with VBA, and I am trying to figure out the syntax to make a cell's contents into a variable.
For example, here is an abridged copy of my code:
Dim emailto as string
Set emailto = *******unknown syntax for value in sheet 1 cell a1**********
Wb.Save
With EmailItem
.Subject = "Invoices and Open Balance Sheets"
.Body = "New Invoices" & vbCrLf & _
.To = emailto
.Importance = olImportanceNormal
.Attachments.Add Wb.FullName
.Send
End With