Jul 6, 2025
Оfftopic Community
Оfftopic Community
Forums
New posts
Search forums
What's new
Featured content
New posts
New media
New media comments
New resources
New profile posts
Latest activity
Media
New media
New comments
Search media
Resources
Latest reviews
Search resources
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Technology
Software & Hardware
sending an email from Excel (mailto: vs. VBS)?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="big_cizzo" data-source="post: 2684054" data-attributes="member: 904917"><p>Hello,</p><p>I currently have an Excel sheet where I log my daily job activity, I also need to send out a lot of emails, so I am trying to optimize my process.</p><p>I have 3 fields of intereset, that I am trying to incorporate into my emails - two ticket numbers and a name (the 2 ticket numbers go into the subject, the name goes to the "To:")</p><p>so I already have the mailto: command (i pasted it 1000 times for each row) with the following syntax:</p><p>=HYPERLINK("mailto:"&D2&"?subject="&M2&"&body="& N2,"email")</p><p></p><p>However, my "body" is only limited to about 2 lines of text, which is not enough.</p><p></p><p>Would anyone be able to assist me with the VB code, that I would have to program, so that I would have a link (button) with the same functionality on every row - composes an email with information, taken from cells within this line in Excel (name and ticket number for the corresponding person)</p><p></p><p>Thanks in advance to everybody!</p><p>Have a great day!</p></blockquote><p></p>
[QUOTE="big_cizzo, post: 2684054, member: 904917"] Hello, I currently have an Excel sheet where I log my daily job activity, I also need to send out a lot of emails, so I am trying to optimize my process. I have 3 fields of intereset, that I am trying to incorporate into my emails - two ticket numbers and a name (the 2 ticket numbers go into the subject, the name goes to the "To:") so I already have the mailto: command (i pasted it 1000 times for each row) with the following syntax: =HYPERLINK("mailto:"&D2&"?subject="&M2&"&body="& N2,"email") However, my "body" is only limited to about 2 lines of text, which is not enough. Would anyone be able to assist me with the VB code, that I would have to program, so that I would have a link (button) with the same functionality on every row - composes an email with information, taken from cells within this line in Excel (name and ticket number for the corresponding person) Thanks in advance to everybody! Have a great day! [/QUOTE]
Insert quotes…
Name
Verification
Please enable JavaScript to continue.
Loading…
Post reply
Top