Sending E-Mail by code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a form which gets E-mailed once a week. At the moment the recipient
E-mail address is written in a code and if I wish to change the address I
have to enter the code and change it that way. Is there a way which I can do
that using a cell on the actual form.
 
ASU said:
I've got a form which gets E-mailed once a week. At the moment the
recipient E-mail address is written in a code and if I wish to change
the address I have to enter the code and change it that way. Is there
a way which I can do that using a cell on the actual form.
Click to expand...

Supposing that the address is held in Sheet1!A1 then swap the hard coded
address for [Sheet1!A1].Value
 
Just the job. It works nicely.
Thank you very much IT God!!
--
ASU


Paul Lautman said:
ASU said:
I've got a form which gets E-mailed once a week. At the moment the
recipient E-mail address is written in a code and if I wish to change
the address I have to enter the code and change it that way. Is there
a way which I can do that using a cell on the actual form.
Click to expand...

Supposing that the address is held in Sheet1!A1 then swap the hard coded
address for [Sheet1!A1].Value
Click to expand...
 

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

Similar Threads

Windows 10 operating system - using firefox browser - yahoo mail. 5
Unread e-mail count in Samsung Oreo update 3
Sky e-mail via outlook 2
sending multipul e-mail from excel 1
GAL does not show up when e-mailing from Excel 2003 4
GOG - 2 step verification e-mail not received 4
send e-mails 1
Send e-mail 3

Back
Top