Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

How to set up a macro to insert a file into an email using an email address in file

  • 4 svar
  • 2 har dette problemet
  • 10 views
  • Siste svar av PJGW

more options

How to set up a macro to insert a file into an email using an email address in file

How to set up a macro to insert a file into an email using an email address in file

All Replies (4)

more options

There is no macro language.

more options

OK lets forget macros - what I am trying to do is short cut the process of sending out personnel email attachments with generic attachments.

I send out monthly a personnel notice to 50 people that has three other attachments.

I make the three attachments as an email template then attach the individual attachment.

It is from this attachment I was hoping I could extract the email address and first name to shorten the process.

more options

What is the master document from which you compile your list of addressees? Could you turn it into, or extract from it, a CSV file of names and email addresses?

If so, then a Mail Merge might be a useful solution for you.

https://addons.mozilla.org/en-US/thunderbird/addon/mail-merge/

But I'm not confident about mailing each addressee a unique attachment. That's kind of outside the remit of an email client. More what payroll software, or more generally, a database is designed for.

Endret av Zenos

more options

Thanks Zenos

Looks like I am at a place I did not want to go.

I have the master in Excel and I was trying to avoid building a database but it looks like that is the way to go PJGW