MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 321|Reply: 9

Collect Data Via Email and Add Attachment [SOLVED]

[Copy link]

1

Topics

4

Posts

11

Integral

Member

Rank: 2

Integral
11
Post on 9-14-2016 18:32:32 | All posts |Read mode
I have a database that has a tblNewRecords that I am using to collect new requests. I am then turning around and sending those requests via an update query to a new table that is used while generating collect data emails. Ideally, I would prefer to send collect data emails that are going to update records, but I need to include an attachment in that email and when you update vs. new in the collect data wizard you're not presented with a physical email before it's sent.
Is there a way to update records and attach a file?
Thanks!




Reply

Props Report

2

Topics

36

Posts

108

Integral

Conqueror

Rank: 3Rank: 3

Integral
108
Post on 9-14-2016 20:00:00 | All posts



run the update query:
docmd.openquery
then send the email with the query:
docmd.sendobject




Reply Support Opposition

Props Report

1

Topics

4

Posts

11

Integral

Member

Rank: 2

Integral
11
 Author| Post on 9-14-2016 20:11:32 | All posts



Can you elaborate?
How are you using the docmd.sendobject and Collect Data function or are you replacing the Collect Data step? And then how are you sending that record and including the attachment?
Thanks!




Reply Support Opposition

Props Report

13

Topics

884

Posts

1937

Integral

King

Rank: 6Rank: 6

Integral
1937
Post on 9-14-2016 21:32:05 | All posts



This is an older tutorial using AC 2003, but the same principals apply with the SendObject command.
http://www.datapigtechnologies.com/f...sendemail.html











Reply Support Opposition

Props Report

1

Topics

4

Posts

11

Integral

Member

Rank: 2

Integral
11
 Author| Post on 9-14-2016 21:40:38 | All posts



This is good!
Also, is there a way to I guess import the attachment that's sent with a Collect Data reply. Example is, database sends out Collect Data email with fields to fill in that will later populate a record and that reply back to the database includes an attachment. If the table already has an attachment field, can the database import the attachment to the record?
Thank!




Reply Support Opposition

Props Report

13

Topics

884

Posts

1937

Integral

King

Rank: 6Rank: 6

Integral
1937
Post on 9-14-2016 22:23:47 | All posts



I have never used this wizard, but from what MS says, that may not be possible
https://support.office.com/en-US/art...C-A4E41A14FA98









Reply Support Opposition

Props Report

1

Topics

4

Posts

11

Integral

Member

Rank: 2

Integral
11
 Author| Post on 9-14-2016 22:30:44 | All posts



darn it!
ok, well thanks for calling that out and sharing the MS Support link.
Thanks.
Reply Support Opposition

Props Report

11

Topics

130

Posts

283

Integral

Conqueror

Rank: 3Rank: 3

Integral
283
Post on 2-7-2017 01:57:36 | All posts



the simple formula












Reply Support Opposition

Props Report

13

Topics

1065

Posts

2355

Integral

King

Rank: 6Rank: 6

Integral
2355
Post on 2-7-2017 02:49:24 | All posts



What is the source of the #VALUE# error? My first thought would be to nest the current function in B so that it returns some kind of text string when it errors, then the sum function ImramBhatti suggested would work fine. Are you familiar with the IFERROR() function? https://support.office.com/en-us/art...6-63f3e417f611
Something like =IFERROR(current formula in B,error)











Reply Support Opposition

Props Report

14

Topics

436

Posts

1026

Integral

King

Rank: 6Rank: 6

Integral
1026
Post on 2-7-2017 03:35:34 | All posts



This is inappropriate language. Further offenses will result in a ban.

Common courtesy is the order of the day. Avoid coarse language, personal attacks and inflammatory remarks. Address your concerns at topics and not at people.
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-24-2017 21:26 , Processed in 0.173084 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!