Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I am using a macro to split a file and distribute via

Customer Question
Hi I am using...

Hi I am using a macro to split a file and distribute via e-mail. The file is being split but the e-mail is not being created and distributed. can you help me?

Technician's Assistant: Who is your email provider (Gmail, Yahoo, Outlook, etc.)?

Outlook

Technician's Assistant: How do you usually access Outlook? On a phone or tablet, or through a web browser?

I'm at work so desktop

Technician's Assistant: What troubleshooting have you tried?

I've changed the e-mail address I've tried copying a macro from a file which worked before I've looked at line by line of the macro I inherited this macro. I did not create it

Technician's Assistant: Anything else you want the Email Expert to know before I connect you?

I don't think so

Submitted: 3 months ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 1 minute by:
3/23/2018
Programmer: armymil2003, Programming Enthusiast replied 3 months ago
armymil2003
armymil2003, Programming Enthusiast
Category: Programming
Satisfied Customers: 528
Experience: A few years studying the various languages.
Verified

Hello and welcome! I would be happy to assist today with your question.

Give me just a moment while I review the information provided.

Ask Your Own Programming Question
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

The macro is on an Excel file, correct?

Ask Your Own Programming Question
Customer reply replied 3 months ago
wait you just charged me $56.00 to ask me if the file is in excel. Am I being charged another $39.00 onc you connect to my computer?
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

The charge itself comes from the website when asking a question. I didn't charge you myself. I am just the expert assigned to your question. The ad you see is just a suggestive ad if you want me to access the file on your PC. What you can do is upload the file to me so I can view it and we don't need to do the secure connect option.

Ask Your Own Programming Question
Customer reply replied 3 months ago
But how much more will I be charged in addition to that $56.00?
Customer reply replied 3 months ago
actually $5.00 + $56.00
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

That's it unless you opt for a secure connect to share your screen. Those are for issues where you want me to see an issue you can't describe.

Ask Your Own Programming Question
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

I help people setup programs that have issues going into the settings of those programs. We don't need that option for an Excel question.

Ask Your Own Programming Question
Customer reply replied 3 months ago
Where can I upload the file without the secure connect?
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

On your screen where you are typing, there should be a paperclip that you can click on.

Ask Your Own Programming Question
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

If it's not letting you or you're having issues with it, you can always use a third party option like https://uploadfiles.io/

Ask Your Own Programming Question
Customer reply replied 3 months ago
because the file is an .xlsm I am getting an error message saying file cannot be read
Customer reply replied 3 months ago
that site is blocked by the company
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

I can give you my email address to send it to me.

***@******.***
Ask Your Own Programming Question
Customer reply replied 3 months ago
Hi have you received the file?
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

I just now received it! Reviewing it now.

Ask Your Own Programming Question
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

Okay, so looking at the code. I see it will prompt a question and then follow up with a series of other steps. At what point does it fail? Is everything still on your "F" drive?

Ask Your Own Programming Question
Customer reply replied 3 months ago
everything is still on my "F" drive. It is failing at Create an e-mail
Customer reply replied 3 months ago
Public Function CreateMail(strTo, strSubject, strBody, strAttachment) As Boolean
Customer reply replied 3 months ago
we just migrated our e-mails to a new address I am thinking that is part of the problem. All I did was change the e-mail address to the new domain
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

Besides changing the domain, did you modify anything else? The reason I ask is I am trying to locate where it calls for the email. I see the function program but trying to figure out how it knows to run it.

Ask Your Own Programming Question
Customer reply replied 3 months ago
hmmm...no I didn't do anything else except change the e-mail. The file is stored on our 'F" drive. I'm not sure if someone else touched the file and broke it
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

Based on this, it looks like it isn't calling for the email so once the file is done, it saves and closes out. Let me look some more into it and see if I can attempt to fix it. Excel is unique with it's VBA scripting because each setup is unique. Although a fix for one sheet might work, it could break another one.

Ask Your Own Programming Question
Customer reply replied 3 months ago
okay, thank you
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

I've tried to add some coding to it to see if I could get it to move forward with the email function. I see what it's trying to do. Does the original file still work even with the bad email addresses?

Ask Your Own Programming Question
Customer reply replied 3 months ago
it splits the file. Then the macro stops. It does not create an e-mail nor send out an e-mail
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

I have some suspicions that someone may have modified the original file beyond the email addresses. I figured it would have asked to send or give an error when trying to send. I don't have an outlook program or email program on my computer, so it should pull up Outlook that's not setup and ask me to set it up. It's not doing that at all.

Ask Your Own Programming Question
Customer reply replied 3 months ago
Can we fix this today? If you need to remote to my computer so you can see what happens o my computer we can do that.
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

What I'll need to do is opt out to let a more experienced Excel expert in this case take over since you have a time constraint on it. I would have continued to mess with it to get it to work. What will happen is I will opt out and let someone else take over. You won't need to do anything and when someone responds, you will get an email.

To the next expert, she has an Excel Macro that is not sending after it compiles the data. It worked at one time but for some reason, it stopped working. She will have to email it to you because the site does not like the format.

Ask Your Own Programming Question
Programmer: armymil2003, Programming Enthusiast replied 3 months ago

I'm sorry I couldn't resolve the issue today but standby and another expert will jump in.

Ask Your Own Programming Question
Customer reply replied 3 months ago
okay thank you for looking into this
Customer reply replied 3 months ago
umm...will I hear from another programmer today?
Programmer: Michael Rademacher, Network Administrator replied 3 months ago
Michael Rademacher
Michael Rademacher, Network Administrator
Category: Programming
Satisfied Customers: 48
Experience: 20 yrs. Experience in Corporate Environment
Verified

Hi,

I am Michael.

Could you copy and paste the macro section that has to do with the mailing into a message?

I will take a look if you want me to.

Thank You

Michael

Ask Your Own Programming Question
Customer reply replied 3 months ago
Hi Michael are you still available to look into this issue?
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask ATLPROG Your Own Question
ATLPROG
ATLPROG
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7,677
7,677 Satisfied Customers
Experience: MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

ATLPROG is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I need 2 macros programmed for Outook 2010 1. In an open
I need 2 macros programmed for Outook 2010 1. In an open reply I need the macro to send the reply and move the email that I replied to a specific folder. 2. In an open reply I need the macro to do the… read more
AAATom
AAATom
Software Engineer
Master\u0027s Degree
42 satisfied customers
Hello, I have a spreadsheet that contains a hyperlink to
Hello, I have a spreadsheet that contains a hyperlink to another spreadsheet. Each day I have to use a macro to update this hyperlink because it has to point to a new file that has its creation date i… read more
AAATom
AAATom
Software Engineer
Master\u0027s Degree
42 satisfied customers
Is there a way to transfer individual lines from an address
Is there a way to transfer individual lines from an address field into fields within separate columns? Example: Column A1 has the complete address. I would like to copy the first line only of the addr… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I want to move every second cell to the cell that is up one
I want to move every second cell to the cell that is up one row and to the right one row. I have not experience in building macros.… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I need a VB script that will allow me to set up a rule to run
I need a VB script that will allow me to set up a rule to run manually in outlook 2010 that will do the following A mail message from a specific person (email address) If it has been read will move th… read more
Suryanto
Suryanto
Computer Engineer
Bachelor's Degree
535 satisfied customers
how do i change the color or bold text in the body of the e-mail
how do i change the color or bold text in the body of the e-mail set up in a macro. For example, in the following macro language i would like to bold and change color to the line as indicated below: t… read more
Ingo U
Ingo U
Master\u0027s Degree
358 satisfied customers
Hey guys -- Im struggling through eliminating duplicates
Hey guys =-- I'm struggling through eliminating duplicates in a long list of name and addresses in an Access Database. I've eliminated all the duplicates I can through using names as the primary key. … read more
Ingo U
Ingo U
Master\u0027s Degree
358 satisfied customers
I have a data set in the form of a bunch of files. I have
I have a data set in the form of a bunch of files. I have written the code via recording a bunch of macros and piecing them together to process the individual file. There are some 300+ files and manua… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I need someone to help me by writing a code that can password
I need someone to help me by writing a code that can password XXXXX all of the excel files in a given folder with different passwords. Also, in doing this, to have a separate program that creates uniq… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hi again John, I have another excel puzzle I need to have
Hi again John, I have another excel puzzle I need to have solved and I was wondering if you were available to look at it for me?… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hi, I need the top row to look like the bootom row.The document
Hi, I need the top row to look like the bootom row.The document will contain 1800 records Mare Owner Address Line 1 Mare Owner Address Line 2 Mare Owner Address Line 3 Mare Owner Address Line 4 Mare O… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have a 6,000 page word document that contains individual
I have a 6,000 page word document that contains individual tables on each page. The problem is the cell widths are too narrow. When I try to expand them manually or with the table properties it only e… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have wrksht 1 as an entry page for an invoice, I have an
I have wrksht 1 as an entry page for an invoice, I have an array formula that copies relevant cells entered by user to another hidden wrksht used as a database, problem is i want to have the array cop… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Im trying to create a macro for Excel 2007 that, when saving,
I'm trying to create a macro for Excel 2007 that, when saving, only allows users to save the file as a name that starts with a specific combination of letters, depending on what the file is. For examp… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
excel vba outlook send mail function question Hello, I
excel vba outlook send mail function question Hello, I need help adding the from line in the below code. The below code works fine now, but I would like to add the from line and send it on behalf of a… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am having trouble understanding Doug Robbins mail merge
I am having trouble understanding Doug Robbins' mail merge with attachment macro. He posted instructions to the website below but I haven't been able to keep up. Could someone walk me through this? ht… read more
Ansh P.
Ansh P.
System Analyst
Bachelor\u0027s Degree
6,393 satisfied customers
thank you again, i clicked that accept and it only allowed
thank you again, i clicked that accept and it only allowed me to pay you again for another question, but maybe you would be willing to answer another question for me and I could compensate higher for … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
O have outlook express on my Microsoft XP version. I had the
O have outlook express on my Microsoft XP version. I had the hard drive cleaned up, so that I could complete the networking of my PC in my office, the printers connected to it by a Router, and my lapt… read more
Mike B
Mike B
Computer Engineering Technologist
279 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x