Can someone point me in the right direction on how to add copied cells into the body of my emails?
What I am wanting to add into the body of the email under the 7 lines would be this table. It starts on L47:U49 and I would love to keep the same format if possible.
Capture.JPG
Source code in file attached
.
.
Paste this code into a routine module:
Please Login or Register to view this content.
Thank you!
So does this take away from the macro that is already in place? I have my email addresses set to this and I cannot have it just send to one person at a time.
Edit: I see what it did once I opened it.
Is there a way to combine what I already have with this? The macro I have already adds the email addresses and wording in email on the 2nd tab "Emailing and Wording"
This way I can do multiple emails at once and change the wording for each brewery.
Thanks for any info
Last edited by burcha22; 04-05-2017 at 09:10 AM.
There's no code of yours to be seen anywhere ?????
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
I am so sorry. It would not let me #PASTE# the code. I thought it was in the file attachment on the 1st email.
Here is the original code that I have.
Here is about as far as I have gotten combining the 2
Please Login or Register to view this content.
This is what was originally given to me.
Please Login or Register to view this content.
Last edited by burcha22; 04-05-2017 at 02:01 PM.
I was able to get everything to work except getting the TO: on the email addresses to work.
I changed a few things around to get the macro to use just 1 line for the BODY wording, but still am having issues with getting the email addresses to be entered.
Once that happens, I will switch the "Display" to "Send" and it should loop around and send to all recipients.
EDIT: I have tried to post the #CODE# but a firewall keeps blocking it. The source code is in the attachment.
Got it to work for what I am doing. Code is in the attachment.
Sorry I couldn't get back to you today. Dr's visits and lots of errands.
Glad to see you have it working to your satisfaction. Let me know if there is anything else and we'll see what we can do.
Cheers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks