All Questions
1,006
questions
0
votes
0
answers
57
views
Email Signature HTMLbody not displaying image
I've got the following code, the issue is that in the signature there is an image that won't display at the end of the codethe error in the signature
I am looking for a solution so the image also ...
- 1
0
votes
0
answers
55
views
Including a hyperlink in email body
I create an email containing:
To: email addresses stored in tab "info" range M2 until empty line
CC: hardcoded email address
Subject: Overview - 'Dateoftoday'
Body:
Dear all,
Please find ...
- 1
0
votes
0
answers
27
views
Power automate import outlook email to excel
I am using Power automate I'm trying to import emails to excel. All new emails automatically added in my excel but I want to add old or existing email.Can you help me if there's a way to add old mails ...
0
votes
0
answers
53
views
How to use long strings of text in Excel formulas (longer than 255 characters)
I have this Excel formula, which I am using to add a long passage of text to an Email sender:
=HYPERLINK("mailto:"&$C$2&"?subject=Feedback from your Project Presentation"&...
0
votes
1
answer
33
views
VBA Submitting Batch Emails to Outlook - Efficiency
Is there any way to submit a collection of MailItem to outlook and instruct it to send them all at once?
Right now my code will loop through thousands of email addresses and send an email every ...
- 148
0
votes
1
answer
70
views
Create an Outlook email and add an Excel Named Range and 3 Charts from a different Worksheet to the email body as images
I'm trying to modify some code from @PeterT, which adds charts as images to an Outlook email. His code works perfectly for adding the charts to an email and is super fast (Thank you @PeterT!)
I'm ...
- 13
-5
votes
1
answer
79
views
Add a clickable link, within the email text body, to a file location
I have Excel VBA code that sends an email.
Data is pulled from various cells to populate the body of text within the email.
I want to add a clickable link, within the email text body, to the file ...
- 11
0
votes
0
answers
41
views
Can I Generate and Send Excel File via Email in Pentaho?
Output: The transformation will send the product master data in the form of an Excel file with the name data_excel_yyyy-MM-dd.xls, where yyyy represents the year, MM represents the month, and dd ...
- 1
0
votes
1
answer
42
views
Add cell value and a selection to mail
I am looking to add a cell value and a selection of a pivot table to my generated email body.
I have an Excel workbook with cells allowing me to fill in certain values from my email (example: .To, ....
- 3
0
votes
0
answers
75
views
Choose from email address when sending?
I want to choose the correct (1) email address from the list of email addresses I have in Outlook?
How do I edit this working code so I can choose the email address to send from?
Currently I manually ...
- 65
0
votes
0
answers
36
views
I can't send email with pywin32 & excel
I have the following code that reads an existing Excel file, change PDF files, and send emails. Among those things sending emails fuction doesn't work. How can I solve it?
here is How macro works
...
0
votes
1
answer
108
views
Email based on the dropdown answer in a specific cell using Excel VBA
Below is code where I have all managers CCed on response email.
I'd rather the content of cell P2 ("Select Your Work Area") direct where that email gets CCed.
e.g. "Snow Camp (3-6)"...
0
votes
0
answers
80
views
Copy table to Outlook mail body inside a loop
I have two dictionaries workerDict and managerDict.
I loop through every teamID of workers to get the manager of that team, then I send email to all members of a team and their managers in cc.
I want ...
- 35
0
votes
2
answers
120
views
Include a range of data using offset in email
I have a list of products in a worksheet which are highlighted different colours to show product groups. Each highlighted colour has a corresponding number (grey = 15, yellow = 19, etc.).
I am trying ...
0
votes
2
answers
123
views
Send different emails via Excel VBA based on cell value
I run a train-the-trainer training. I have a spreadsheet to create a PDF attendance certificate and an email to confirm they have passed the course to take on the trainer role.
This is all done via ...
- 45